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.
|