Frank! - (Insert 'x' No. of Rows)

A

Al-Blakie

Hi Frank, would you be able to give me an example of how to insert 'x' no. of
rows into an excel doc.
Any help would be much appreciated.
Al
 
D

Don Guillett

You could have waited more than 2 minutes to re-post. Frank is still
sleeping which is unusual but this will insert 3 rows at the active cell

Sub insert3rows()
ActiveCell.Resize(3, 1).EntireRow.Insert
End Sub
 
A

Al-Blakie

Sorry about re-post, my explorer crashed....should have waited.

Thanks for the example... works a treat.
Al
 
F

Frank Kabel

Hi Don
not sleeping but working :)
for me it's 3:45 pm (and definetly too hot outside!)

Frank
 
Top