variable that keeps its value until reset

  • Thread starter Thread starter Jamie Martin
  • Start date Start date
J

Jamie Martin

Hi,

How can I declare a variable that will keep its value not only after a
procedure is run, but when Excel or the computer is shut down--that will
keep its value until it is reset?

THanks,

Jamie
 
The place you might be thinking of storing your variable
might be within your VBA code. This can be done and it
might best be stored in a little two line routine that can
be called as required.
Self modifying code is possible but you will have to
search the internet or MS Knowledgebase for a good lead.
 
Back
Top