Should be easy...what's missing?
Just split it up into 2 lines (and don't use the 'destination'):
Worksheets("Sheet3").Range("Q2:V2").Copy
Worksheets("Sheet2").Cells(c.Row, "A") .PasteSpecial xlPasteValues
On Mar 29, 4:16*pm, MovingBeyondtheRecordButton
.com wrote:
The "copy Destination:=" sounds like it would work but how do I tell it to
copy Destination Values only?
|