RE: .Copy Destination:= Paste Special?????

[BIGTONE559]

RE: .Copy Destination:= Paste Special?????

Greetings,

When copying data from one sheet to another i would like to just paste values.


i have the following line of code:

Range(Cells(cell.Row, 1), Cells(cell.Row, 5)).Copy Destination:=Sheets("Summary").Cells(destrow, 15)

however, i'm confused about the syntax in regards to paste special. Is there a way to do so using destination or is there a more efficient way? if so how do you do it?

Thanks

 

[VoG]

Re: .Copy Destination:= Paste Special?????

Try

Range(Cells(cell.Row, 1), Cells(cell.Row, 5)).Copy
Sheets("Summary").Cells(destrow, 15).passpecial Paste:=xlPasteValues

 

[BIGTONE559]

Re: .Copy Destination:= Paste Special?????

As usual your my knight in shiny armor. I'm getting a little more accustomed to the syntax every now and again i hit a snag. I appreciate the help.