Insert a Row Below

mjones

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
 
Sort by date Sort by votes
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.
You must log in or register to reply here.

Similar threads

M
  • Question
Add a new row every second and copy text.
Replies
3
Views
126
Joe4
Joe4
A
  • Question
I'm trying to float a button at the bottom of an Excel table
Replies
1
Views
472
skillilea
S
DTMnBHM
  • Question
Insert blank row and copy row to new blank row
2
Replies
13
Views
620
Coyotex3
C
W
  • Solved
Adding Rows & Copying Data in Row Above
2
Replies
11
Views
454
Wilconcl51
W
M
  • Solved
VBA Help - Duplicate & Unwanted Data Removal
Replies
6
Views
249
MoonDancer
M

Forum statistics

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

Share this page

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