Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Howdy all.
I have a workbook with around 7 modules. Each module refer's to a few cells in one worksheet, to create a few variables. I want to be able to declare those variables as global, so i dont have to have the same variable declaring coding in each module. Can this be done by simply making another module and putting the declarations in as Public, instead of Dim? (Note: i need to keep macro'sin seperate modules for cleanlyness...) Any assitance is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Declaring variables for use in multiple worksheets | Excel Discussion (Misc queries) | |||
Overflow error when declaring variables | Excel Discussion (Misc queries) | |||
Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
Declaring variables | Excel Discussion (Misc queries) | |||
Declaring variables | Excel Discussion (Misc queries) |