D
Deborah Allen
I know there is a macro that when active, will
automatically add additional lines to a worksheet. What
is that macro?
automatically add additional lines to a worksheet. What
is that macro?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
I
icestationzbra
i dont think there is a readymade macro like that, you would have t
write one
write one
M
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
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
G
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
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