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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Sorry about re-post, my explorer crashed....should have waited.

Thanks for the example... works a treat.
Al
 
Hi Don
not sleeping but working :-)
for me it's 3:45 pm (and definetly too hot outside!)

Frank
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return the values for the same names across a row of data 7
Making a specific row number active from a cell entry 15
'Cannot insert object' message when I try to put a button on a worksheet 7
Hlookup with multiple same values? 3
Script to insert Row 2
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Adding a specified number of rows in Excel, via a User Form 0

Back
Top