Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Where can I view a compiled list of reserved words?
-- Thank you for your time. Windows XP Office 2002 "Jim Thomlinson" wrote: Assuming this to be the problem, then this is one of the reasons I suggested in my original response prefacing your module names with m or mod... mSheets or modSheets are perfectly acceptable names that will not conflict with any reserved words in VBA. I probably should have mentioned that in my first post. -- HTH... Jim Thomlinson "Rowan Drummond" wrote: You didn't name one of your modules "Sheets" did you?? When renaming modules it is important not to use any terms already used by VBA and also not to use a name that you have also used for a macro, function or userform. Regards Rowan justaguyfromky wrote: I have renamed all of my modules and moved macros into the corresponding module that best catagorizes them. Now I keep getting errors. Expected variable or procedure, not module When this error comes up the word sheets is always highlighted. Why is this happening? Any Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Module error | Excel Discussion (Misc queries) | |||
compile error in hidden module | Excel Discussion (Misc queries) | |||
error "module not found" | Excel Discussion (Misc queries) | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Compile error in hidden module error | Excel Programming |