Is it possible to cut and delete a row in 1 step?
D Don Guillett May 13, 2004 #2 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
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 May 14, 2004 #3 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.
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.