![]() |
Undeclared variables allowed in a Module defined with Option Expli
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. |
Undeclared variables allowed in a Module defined with Option Expli
"cgr" wrote:
A module in my project allows undeclared variables to be created even though Option Explicit is defined. Are the variables that are "allowed" declared as global in the other modules? |
Undeclared variables allowed in a Module defined with Option E
No.
"AA2e72E" wrote: "cgr" wrote: A module in my project allows undeclared variables to be created even though Option Explicit is defined. Are the variables that are "allowed" declared as global in the other modules? |
Undeclared variables allowed in a Module defined with Option Expli
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. "cgr" wrote: 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. |
Undeclared variables allowed in a Module defined with Option E
No.
"AA2e72E" wrote: "cgr" wrote: A module in my project allows undeclared variables to be created even though Option Explicit is defined. Are the variables that are "allowed" declared as global in the other modules? |
All times are GMT +1. The time now is 05:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com