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?
|