I just tried the macro code that Chip suggested earlier in this thread
and it worked fine. It shows up in Macro box and executes. I was
wondering if someone whio has the same config as me could try
copy/pasting David's code and see if works for them.

Thanks.

Mike

Hi Mike,

If Chip's code works for you, so too should David's suggestion: the two are
completely synonymous.


---
Regards,
Norman


"mht53nyc" wrote in message
oups.com...
I just tried the macro code that Chip suggested earlier in this thread
and it worked fine. It shows up in Macro box and executes. I was
wondering if someone whio has the same config as me could try
copy/pasting David's code and see if works for them.

Thanks.

Mike

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.

Generally the Sub is written to be called from an event which David shows
later on down the page.

The following is an Event Macro, and will insert 3 rows without prompting,
this one is triggered by a Double Click. (see next two topics about
installaton of an Event macro)

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True 'Get out of edit mode
Application.Run "personal.xls!InsertRowsAndFillFormulas", 3
End Sub


Gord Dibben Excel MVP

On 13 Dec 2005 07:34:22 -0800, "mht53nyc" wrote:

I just tried the macro code that Chip suggested earlier in this thread
and it worked fine. It shows up in Macro box and executes. I was
wondering if someone whio has the same config as me could try
copy/pasting David's code and see if works for them.

Thanks.

Mike

Gord:

Thank you!! I will try this later. It was not apparent that I needed to
do this when I looked at the page that contained the code but after
your response I followed David's link on PROPER and I see it is
described in detail.

Thank you again.

Mike

Thanks for the feedback and good luck with the project.


Gord

On 13 Dec 2005 11:21:37 -0800, "mht53nyc" wrote:

Gord:

Thank you!! I will try this later. It was not apparent that I needed to
do this when I looked at the page that contained the code but after
your response I followed David's link on PROPER and I see it is
described in detail.

Thank you again.

Mike

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.