Copy-Paste Opearions

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, and 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  the Entire data from one sheet to another

For example if you want to copy the data “Sheet1” and paste it to in “Sheet2”.

For copy the data present in “Sheet1”

mainworkBook.Sheets(“Sheet1”).UsedRange.Copy

Read more

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, and 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 the Entire row data and paste it to another row.

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

For copy the data present in row 5 from “Sheet1”

mainworkBook.Sheets(“Sheet1”).Rows(5).EntireRow.Copy

Read more

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

Read more