Thread: [Solved] How do we add one or more rows manually( by typing row numbers). ?
View Single Post
 
Old 01-02-2016, 12:32 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
That definitely doesn't explain anything.
Between which two rows?
Where are you typing those row numbers?

Here's what I'd do to quickly insert 25 blank rows between the existing rows 3 and 4.

Alt + F11 to bring up the VBA environment
Ctrl + g to bring up the immediate window
Type in
Code:
Rows(4).Resize(25).Insert
Hit Enter.
Reply With Quote