What is the syntax to copy a range onto another range

Range("<old range>").Copy Destination:=Range("<your new range>")

(ex) Range("A1:C5").Copy Destination:=Range("E1:G5")

copyrange.JPG

 

Advertisements