Vba copy range from one sheet and paste to another

[Joshua88]

Hello I am trying to copy data from a range on one sheet and paste to another, dilemma I am pasting it to a merged sell, I know stupid, but I can paste it as a link and get what I'm looking for, but I'm having trouble righting to code, I'm thinking I need to put .paste link:=true some where, but I'm not sure any help would be great

Sheets("DataDump3").Range("A2:B13").Copy Destination:=Sheets("Cnc Sheet").Range("A15")

 

[Nine Zero]

Try without the destination part

Sheets("DataDump3").Range("A2:B13").Copy Sheets("Cnc Sheet").Range("A15")

 

[Joshua88]

still merged cell error, if I right click and past link it works, not sure how to past link in vba