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 impor­tant role, we can copy data from one place and paste it at some other place in the same way like how we do it man­u­ally, and when you copy some data its goes to the Clip­board from there you can paste it at some other location.

Dim main­work­Book As Workbook

Set main­work­Book = ActiveWorkbook

Copy the Entire row data and paste it to another row.

For exam­ple  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 clip­board, you can check it by man­u­ally past­ing it in a notepad.

Now select the cell in which you want to paste the data, in this exam­ple 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: