How do I change it from inserting one row to inserting 11 rows at once?
Thanks.

"Chip Pearson" wrote:

Try the following VBA macro:

Sub InsertRows()
Dim RowNdx As Long
Dim LastRow As Long

LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For RowNdx = LastRow To 2 Step -1
Rows(RowNdx).Insert
Next RowNdx

End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kwm5321" wrote in message
...
In Excel, is it possible to insert a 'blank' (new) row between
each row of
exisitng text?