VBA How to Copy Cells and Ranges

Recommended method, faster performance to copy only values, avoiding cut/copy slowness and without need to select objects

Sheets(1).Range("D5:J8").Copy Sheets(2).Range("A7:G10")

Alternative method, recommended to copy values + formats.

Sheets(1).Range("D5:J8").Copy Sheets(2).Range("A7:G10")

Recommended method to copy formulas.

Sheets(1).Range("D5:J8").Copy
Sheets(2).Range("A7:G10").PasteSpecial Paste:=xlPasteFormulas

Perform multiple paste special operations at once.

Sheets(1).Range("A7:A20").Copy
Sheets(2).Range("B1").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:= False, Transpose:=True
Subscribe
Subscribe