Adding Lines to a worksheet

[Deborah Allen]

I know there is a macro that when active, will
automatically add additional lines to a worksheet. What
is that macro?

 

[mzehr]

Hi Deborah,
Try this posting by Bob Phillips:

Sub InsertRowsAndFillFormulas()
Dim x
x = InputBox( _
prompt:="How many rows do you want to add?", _
Title:="Add Rows")
If x = "" Or x < 1 Then
Exit Sub
Else
ActiveCell.Resize(x, 1).EntireRow.Insert
End If

End Sub

 

[icestationzbra]

i dont think there is a readymade macro like that, you would have t
write one

 

[mzehr]

Hi Deborah,
I don't know why I overlooked this resource for you, but
try out David McRitchie's valuable website for some
additional info:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm#insrtrow

 

[Gord Dibben]

Deborah

What kind of lines?

Do you mean "rows"?

Where would these be placed. How many? Under what conditions?

If you want more than 65536 rows on a worksheet, you can't do that.

Gord Dibben Excel MVP