Cut & delete row in 1 step

D

Don Guillett

If I understand you correctly, if you delete a row it is cut. you can use
cut in a maco to move info.
Sub cutrow()
Rows(3).Cut Sheets("sheet2").Rows(2)
End Sub
 
D

Dave Peterson

I'm guessing that the OP really wanted the remaining rows shifted up.

This left an empty row 3 for me.

I've always deleted the row after cutting|pasting.
 
Top