Excel VBA Cut & paste active row on an active sheet,active row to first blank row on another worksheet

Question

I can copy and paste from an active sheet and active row to an "Activesheet_Archivesheet" on the next blank line but if I try and cut and paste I cannot find the code to find the next blank line and "paste". Any pointers please? (ie if I have missed a previous post).

Excel VBA

If an answer helped you, then please mark it as correct. – Timothy Alexis Vass Jul 25 '21 at 09:03 — Timothy Alexis Vass, Jul 25 '21 at 09:03

score 0 · Answer 1 · answered Jul 23 '21 at 20:45

0

For column A, this selects the next empty row and ignores blanks in the data set.
As you see, it gets the empty row from the bottom.

Range("A" & Rows.Count).End(xlUp).Offset(1).Select

answered Jul 23 '21 at 20:45

Timothy Alexis Vass

2,526
2
11
30

Excel VBA Cut & paste active row on an active sheet,active row to first blank row on another worksheet

1 Answers1