There are a few different ways to accomplish this task, and the macro recorder doesn’t always give you the most efficient VBA code.
In the following three videos I explain:
The most efficient method for a simple copy and paste in VBA.
The easiest way to paste values.
How to use the PasteSpecial method for other paste types.