Worksheets("Sheet1").Rows("3:3").Copy _
Destination:=Worksheets("Sheet2").Range("A65536").End(xlUp).Offset(1)
The above code copy all information to the destination, is it possible to copy the value only?
Is it possible to include "selection.PasteSpecial Paste:=xlPasteValues" in the above code?
Thanks
Destination:=Worksheets("Sheet2").Range("A65536").End(xlUp).Offset(1)
The above code copy all information to the destination, is it possible to copy the value only?
Is it possible to include "selection.PasteSpecial Paste:=xlPasteValues" in the above code?
Thanks