Thread: Module Error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
James Kendall James Kendall is offline
external usenet poster
 
Posts: 13
Default Module Error

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?