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.

Variable life
 

Non-array variables are exactly the same, if declared at the module level.

--
Jim Rech
Excel MVP