Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable life
Hello. Please help me if you can.
If you "Dim" an array at module level, the contents of the array survive after the code stops running. For example, I can load up an array with one button click. After that program stops, I can then change sheets (or whatever) and click another button and do something with the contents of that array in a completely separate subroutine. Is there a way to do this with a single element variable? If so, could you supply me with the example code to do it? Thanks in advance for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable life
Non-array variables are exactly the same, if declared at the module level.
-- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
!very important for your life... | Excel Worksheet Functions | |||
life contingencies | Excel Worksheet Functions | |||
Simplify my life with if... | Excel Worksheet Functions | |||
Money for life | Excel Worksheet Functions | |||
Money for life | Setting up and Configuration of Excel |