Insert a Row Below

mjones

Board Regular
Joined
Oct 27, 2007
Messages
97
Office Version
  1. 365
Platform
  1. Windows
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
 
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.

VBA Code:
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.
 
Last edited:
Upvote 0

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top