Click here for important information about Computing.net.

Solved randomly copy and paste rows from one sheet to another

April 16, 2020 at 03:19:45
Specs: Windows 10
Hi,

I saw the code on this link:
https://www.computing.net/answers/o...

The code works well. I just need to tweak it so it would paste starting from the 2nd row of sheet 2 onwards

Please help! Thanks :)

message edited by waferstix


See More: randomly copy and paste rows from one sheet to another

Report •

#1
April 16, 2020 at 05:50:12
✔ Best Answer
Try changing this:

Destination:=Sheets(2).Cells(copyRow, 1)

to this:

Destination:=Sheets(2).Cells(copyRow + 1, 1)

Let us know if that works. If it doesn't, tell us what doesn't work.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Start a discussion
Related Solutions
See More ↓


Ask Question