Module error?
 

Can someone explain why two subprocedures in the same module are listed
differently in the Macros dialog box? The procedures are called Test1 and
Test2. When I choose Tools Macro Macros, the first displays as Test1,
but the second displays as Module1.Test2.

It seems that Test2 runs correctly, but it also frequently causes one of
those "Send Error" messages and shuts down Excel. Is the way these are
listed telling me that there's something potentially wrong with my code?
--
Steve C

Module error?
 

You apparently have another module in your workbook which also has a sub
procedure named Test2. The dialog only displays the minimum amount of
information to discriminate the procedure uniquely from the context of the
activeworkbook.

--
Regards,
Tom Ogilvy


"Steve C" wrote:

Can someone explain why two subprocedures in the same module are listed
differently in the Macros dialog box? The procedures are called Test1 and
Test2. When I choose Tools Macro Macros, the first displays as Test1,
but the second displays as Module1.Test2.

It seems that Test2 runs correctly, but it also frequently causes one of
those "Send Error" messages and shuts down Excel. Is the way these are
listed telling me that there's something potentially wrong with my code?
--
Steve C

Module error?
 

Hi Steve,

Do you have a macro named Test2 in another module?


---
Regards,
Norman



"Steve C" wrote in message
...
Can someone explain why two subprocedures in the same module are listed
differently in the Macros dialog box? The procedures are called Test1 and
Test2. When I choose Tools Macro Macros, the first displays as Test1,
but the second displays as Module1.Test2.

It seems that Test2 runs correctly, but it also frequently causes one of
those "Send Error" messages and shuts down Excel. Is the way these are
listed telling me that there's something potentially wrong with my code?
--
Steve C

Module error?
 

I discovered that I had referenced a named range with the same name, Test2,
as my sub procedure. When I renamed the subprocedure, it displayed properly.
Thanks for steering me in the right direction.
--
Steve C


"Tom Ogilvy" wrote:

You apparently have another module in your workbook which also has a sub
procedure named Test2. The dialog only displays the minimum amount of
information to discriminate the procedure uniquely from the context of the
activeworkbook.

--
Regards,
Tom Ogilvy


"Steve C" wrote:

Can someone explain why two subprocedures in the same module are listed
differently in the Macros dialog box? The procedures are called Test1 and
Test2. When I choose Tools Macro Macros, the first displays as Test1,
but the second displays as Module1.Test2.

It seems that Test2 runs correctly, but it also frequently causes one of
those "Send Error" messages and shuts down Excel. Is the way these are
listed telling me that there's something potentially wrong with my code?
--
Steve C