Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

VBA-Excel: Copy/Paste data – Copy the Entire row data and paste it to another row

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

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(“A1”).Select

Now paste the data

mainworkBook.Sheets(“Sheet2”).Paste

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: