Variable life

  • Thread starter Thread starter morph
  • Start date Start date
M

morph

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