Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maximum number of variables allowed in an Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
use of module level variables | Excel Programming | |||
Variables Held in Sheet Module | Excel Programming | |||
Passing variables from module to userform | Excel Programming |