XL Copy and Paste a Range

20201007 0834 

"www.excelhowto.com/macros/excel-vba-copy-and-paste-a-range/"

 

Sheets("Sheet1").Range("A1:D5").Copy
Sheets("Sheet1").Range("A7:D11").PasteSpecial xlPasteFormulas

Note: To remove the animation around the copied cell add below code:

Application.CutCopyMode = False

 
1) xlpastevalues
2) target(destination) range's size does not need to be same as original range. Just targeting starting point(upper left corner) is enough.

 

...