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")




What is the syntax to select cells?

To select a single cell

Range("<Cell Value>").Select
(ex) Range("A1").Select
(ex) Range("C3").Select


To select a continuous range

Range("<Cell Value>").Select
(ex) Range("A1:B4").Select
(ex) Range("C3:F400").Select


To select multiple non-continuous ranges

Range("<Cell Value>, <Cell Value>").Select
(ex) Range("A1:E3, H2:H44").Select
(ex) Range("C3:D4, Y3:Y4").Select


To select down to the 1st empty cell

Range(Selection, Selection.End(xlDown)).Select