Can you give me an example of how i could do this using VBA. Any help is much appreciated.
A Al-Blakie Aug 9, 2004 #1 Can you give me an example of how i could do this using VBA. Any help is much appreciated.
M mzehr Aug 9, 2004 #2 Hi, Try the following posted earlier 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 HTH
Hi, Try the following posted earlier 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 HTH
A Al-Blakie Aug 9, 2004 #3 Sorry about re-post, my explorer crashed....should have waited. Thanks for the example... works a treat. Al
Sorry about re-post, my explorer crashed....should have waited. Thanks for the example... works a treat. Al
