Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best place to declare variables
Where is the best place to declare variables, in terms of
memory utilization, etc. if the same variable names are used in different modules, although their values do not (always) need to be passed between modules. ex: Module A is used to summarize data on Sheet1 of a Workbook into Sheet2 Module B is used to summarize data on Sheet3 of a Workbook into Sheet4 There are no common functions/subs between Module A and Module B (Module C has functions/subs called by both Module A and B - but that could be a red herring) In Module A and Module B I use the same variable names - just for consistency. Is it more efficient to declare the variables with DIM in Module A & Module B or to declare them as Public elsewhere? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declare variables to a code? | Excel Discussion (Misc queries) | |||
Declare Variables in Array | Excel Discussion (Misc queries) | |||
Declare and Set Public variables | Excel Discussion (Misc queries) | |||
how to declare local variables for Excel.Workbook at runtime. | Excel Discussion (Misc queries) | |||
How to efficiently declare variables | Excel Discussion (Misc queries) |