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

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

--
Message posted from http://www.ExcelForum.com

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

Try

ActiveCell.EntireRow.Copy

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

--
Message posted from http://www.ExcelForum.com