How to Copy & Paste in Excel VBA

Updated July 20, 2017

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.

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

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

Private Sub copyAndPaste()

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

Type "End Sub" to end the sub procedure.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Jaime Avelar is a professional writer whose programming articles appear on various websites. He has been a software programmer since 2000. Avelar holds a Master of Science in information systems from the University of Texas at Arlington.