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.
-----Original Message-----
Jamie,

You would have to store it in the registry or write it to
a text file.

Have a look at help on SaveSetting and GetSetting.

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Jamie Martin" wrote in message
...
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




.