View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
AB[_2_] AB[_2_] is offline
external usenet poster
 
Posts: 236
Default 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?