VBA-Excel: Copy/Paste data - Copy the data from a call and paste it to another cell

In VBA-Excel, Copy and paste the data plays an important role, we can copy data from one place and paste it at some other place in the same way like how we do it manually, when you copy some data its goes to the Clipboard from there you can paste it at some other location.

Dim mainworkBook As Workbook

Set mainworkBook = ActiveWorkbook

Copy a data from a call and paste it to another cell

For example if you want to copy the data from cell “C6” of “Sheet1” and paste it to “B2” in “Sheet2”.

First copy the data present in cell “C6” from “Sheet1”

mainworkBook.Sheets("Sheet1").Range("C6").Copy

now the data has been copied to clipboard, you can check it by manually pasting it in a notepad.

Now select the cell in which you want to paste the data, in this example its “B2” in “Sheet2”

mainworkBook.Sheets("Sheet2").Range("B2").Select

Now paste the data

mainworkBook.Sheets("Sheet2").Paste

Also Read:

1. VBA Codes - Record Macro
2. VBA-Excel: Cells Ranges Offset - Active Cell
3. VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
4. WorkBooks and WorkSheets
5. Excel-VBA : Open a Excel File using Another Excel File using Browse Option.