Undeclared variables allowed in a Module defined with Option Expli

C

cgr

A module in my project allows undeclared variables to be created even though
Option Explicit is defined.

Any idea why?

The remaining modules (all defined with Option Explicit) in the project do
not allow undeclared variables to exit.
 
A

AA2e72E

cgr said:
A module in my project allows undeclared variables to be created even though Option Explicit is defined.
Click to expand...

Are the variables that are "allowed" declared as global in the other modules?
 
C

cgr

I forgot to mention that the way I fixed(?) the problem was by adding a new
module to the project, copying all of the code from the offending module to
the new module, removing the offending module and then renaming the new
module with the offending module's name. This worked.

I still would like to know why Option Explicit failed in the old module.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a macro only work on certain files 2
Repost: Excel 2007 and Declaring Variables 1
Defining public/global variables in more than one place 1
VBA word change keys 0
Variable Not Defined 3
Option Explicit - Bug? Feature? User Failure? 8
New problem! All variables have to be defined? 5
How to call module function or sub from the Add In? 3

Top