Oops sent to wrong forum: Excel Macros
 

Hi: I have a workbook with 14 worksheets. I need 14 macros

I want the name of the macro to be the name of each worksheet. ex. FA2E,
FA3E, FA4E, etc. the macro is the same except for referencing the worksheet
name.
I have the first macro and am copying/pasting 14 times, changing the
worksheet name and macro name.
However, it doesn't work properly. About the 5 copy/past excel seems to
want to call the macro by the name of the workbook, dot, worksheet. What am
I doing wrong.
When I open up tools, macro, I want to see the 14 names as stated above.
Because, I have a final macro that calls each macro, so I would call,
FA23, FA3E etc.

Help would be appreciated.

Oops sent to wrong forum: Excel Macros
 

Dar -

If the macro is the same other than the worksheet name, why don't you just
use the one macro, and use a variable name for the sheet name. This will be
much easier to maintain.

--
Daryl S


"Dar" wrote:

Hi: I have a workbook with 14 worksheets. I need 14 macros

I want the name of the macro to be the name of each worksheet. ex. FA2E,
FA3E, FA4E, etc. the macro is the same except for referencing the worksheet
name.
I have the first macro and am copying/pasting 14 times, changing the
worksheet name and macro name.
However, it doesn't work properly. About the 5 copy/past excel seems to
want to call the macro by the name of the workbook, dot, worksheet. What am
I doing wrong.
When I open up tools, macro, I want to see the 14 names as stated above.
Because, I have a final macro that calls each macro, so I would call,
FA23, FA3E etc.

Help would be appreciated.