How to Copy & Paste in Excel VBA

Copying and pasting data from one cell to another is a common task in Microsoft Office Excel. Getting this task done using Visual Basic for Applications, or VBA, can save you a lot of time if you have to copy and paste in many spreadsheets, because VBA allows you to write sub procedures that you can execute to perform a task such as copy and paste. Use VBA's Selection.Copy method to copy data in a particular cell and paste it in another using the Paste method.

...
Save time by using Excel VBA's copy and paste functions.

Step

Launch Excel and type “copy this data” in cell A1. Click the “Developer” tab and click “Visual Basic.” Insert a new module by clicking the “Insert” menu and “Module.”

Step

Start a new sub procedure in Visual Basic Editor by typing the following VBA code:

Step

Private Sub copyAndPaste()

Step

Continue by adding the following VBA code to copy A1 data to D1:

Step

Type “End Sub” to end the sub procedure.