View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default Storing values to arrays for subsequent use

Don Lloyd (ably assisted by Toppers) provided me with an excellent solution
for my hiding visible toolbars on opening/redisplaying them again when
closing issue earlier today.
However, I'm still intrigued by the possibility of storing a value to a
variable or an array, then having those values preserved for use later on.
Of course, one way to do this is to store the values in a dummy worksheet,
but I've always thought this to be a bit untidy.
Does anyone have any observations on the best way to do this, if indeed it's
possible?

Thanks in advance

Pete