how to ad paste special values to copy destination

[lucinenecka]

Hello,

Could any one help me how to add paste special values to my statement:

Range("C10").Copy Destination:= _
Sheets("Sheet2").Range("E" & Rows.Count).End(xlUp).Offset(1)


Thank you very much for your help in advance

Regards
Lucie

 

[VoG]

Try like this

Range("C10").Copy
Sheets("Sheet2").Range("E" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues

 

[lucinenecka]

Thank you!