Paste special issue

[olympiac]

What do I need to add in the line below to paste special the value copied?

Selection.Copy Destination:=Sheets("combined").Range("A65536").End(xlUp)(2)

I tried this one but it doesn't work

Selection.Copy Destination:=Sheets("combined").Range("A65536").End(xlUp)(2).PasteSpecial Paste:=xlPasteValues

 

[Arcticwarrio]

.PasteSpecial Paste:=xlValues,

 

[VoG]

You need two lines of code for that

Selection.Copy
Sheets("combined").Range("A65536").End(xlUp)(2).PasteSpecial Paste:=xlPasteValues

 

[olympiac]

Thanks