Hi,
I am trying to insert a blank row at first row but it keeps inserting the row at wrong place although I am selecting row number 1 in the code.
Thank you.![]()
Sub testtest() ActiveCell.EntireRow(1).Select Selection.Insert Shift:=xlUp End Sub
Hi,
I am trying to insert a blank row at first row but it keeps inserting the row at wrong place although I am selecting row number 1 in the code.
Thank you.![]()
Sub testtest() ActiveCell.EntireRow(1).Select Selection.Insert Shift:=xlUp End Sub
Last edited by JBeaucaire; 07-14-2012 at 03:14 AM. Reason: added code tags, you may receive infractions if you keep forgetting. Take care...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks