Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compiler Error - Not an Appropriate Name
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiler Error | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Excel Compiler | Excel Discussion (Misc queries) |