I've got what I believe to be an organization problem in my Excel
macros (using 97-2003 version).

Here's the situation:

In Option Explicit Module1 I have a program which calls a bunch of sub
routines from Module3 which is an Option Private Module.

This works fine.

Now I'm adding into other variations to the macro on Module1, so I've
made Module4 contain a macro which uses one of the sub routines on
Module3 (Option Private Module), only I'm getting the following error:
Compilation Error: Not an appropriate name: TeishutsuItemRow

I have listed TeishutsuItemRow as a public variable on my new macro on
Module4. What code rule am I violating? Is there anyway I can reuse
a sub routine on an Option Private Module sheet in multiple macros
located on multiple modules?

Thanks, NP

To further explain here -

Several of the macros use the same variables. This probably means
that I should combine the modules then, rather than have them
separate. I just wanted to avoid having a HUGE long module, and
thought that breaking it up into different modules would be easier to
understand.

Will be tweaking with it to see what works.

Anybody else who's encountered this problem and could give two cents
would be appreciated.

Thanks, NP

On 7¤ë16¤é, ¤È«e9:23, pallaver wrote:
I've got what I believe to be an organization problem in my Excel
macros (using 97-2003 version).

Here's the situation:

In Option Explicit Module1 I have a program which calls a bunch of sub
routines from Module3 which is an Option Private Module.

This works fine.

Now I'm adding into other variations to the macro on Module1, so I've
made Module4 contain a macro which uses one of the sub routines on
Module3 (Option Private Module), only I'm getting the following error:
Compilation Error: Not an appropriate name: TeishutsuItemRow

I have listed TeishutsuItemRow as a public variable on my new macro on
Module4. What code rule am I violating? Is there anyway I can reuse
a sub routine on an Option Private Module sheet in multiple macros
located on multiple modules?

Thanks, NP