VB for copy & paste values (not formula's)

E

Eager2Learn

Hello,
I am using the follow vb to copy a row from one sheet and paste t
another. How can I alter this to only paste the values and not th
formula's? Help.

Dim rng As Range
Set rng = Sheets("COMPLETED").Range("A"
Rows.Count).End(xlUp).Offset(1, 0)
ActiveCell.EntireRow.Copy Destination:=rng

thanks!
E2
 
M

mudraker

Try

ActiveCell.EntireRow.Copy

rng.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=Fals
 
Top