Hi Mike (and Gord),

Actually, I invoke InsertRowsAndFillFormulas
from a **toolbar button** , but I did also include several
Event macros on the page that could be used. I use the
toolbar button for all but a small number of pages.
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Information on toolbar buttons and a picture of toolbar
buttons that you can copy and paste to your toolbar are in
http://www.mvps.org/dmcritchie/excel...ars.htm#macros

If you want a subroutine to use from Alt+F8 (macros) you could use
the following, which is now included:

Sub InsertRowsAndFillFormulas_caller()
Call InsertRowsAndFillFormulas
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gord Dibben" <gorddibb ...... wrote
Mike

Is this the Sub you copied from David's site?
Sub InsertRowsAndFillFormulas(Optional vRows As Long = 0)

It has arguments, you won't see it in the ToolsMacroMacros dialog and must
be called from another Sub.