Thread: Variable life
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
morph morph is offline
external usenet poster
 
Posts: 1
Default 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.