Insert a Row Below

[mjones]

Hi All,

Is there a way to insert a row below the row you’re on?

I know, you’ll say to go to the row below that one and insert, which inserts a row above and below the row I want. HOWEVER, I can’t go to the row below because it’s likely filtered out.

Currently, I’m unfiltering, finding the row again (why won’t Excel stay on the row I’m on after unfiltering – I digress), go to the row below, add the row above, and filter again . . . very cumbersome when doing it hundreds of times in a 7200-row spreadsheet.

Thanks again,

Michele

 

[Burrgogi]

Michele, I know you already have your answer but here's another VBA solution that was given to me by @Alex Blakenburg. He's very good with VBA. It's a very simple 1 line script that does the exact same thing.

Sub InsertRow_v2()
ActiveCell.Offset(1).EntireRow.Insert
End Sub

It's a very efficient solution that barely uses any resources (like CPU or memory). Normally this would only matter if it was a long complex script was doing a lot of fancy things in the background but in a case like yours where it's just executing just 1 simple task, you won't notice any difference at all. I'm posting it here in case you want to use it and for others who are still learning VBA like myself.

 

[mjones]

Yes, it is very fast. Thank you Burrgogi.