Undeclared variables allowed in a Module defined with Option Expli

G

Guest

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.
 
G

Guest

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

Guest

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

Repost: Excel 2007 and Declaring Variables 1
Defining public/global variables in more than one place 1
How to create a bubble chart with more than 2 variables 0
Option Private Module 3
Option Explicit - Bug? Feature? User Failure? 8
Option Explicit set at Application Level by Excel Add-in? 10
Problem with VBA code written in Excel 2002 working in Office 2003 2
Vista Macros 5

Top