Maintaining VBA variable values
How can I get my variables to keep their values when I close my Excel file?
In other words, I have some Dim statements at the top of my code so the
variables keep their values while I run different sub routines; however, when
I close and re-open the file, the values are lost -- is there a way to save
them?
(As you can probably tell, I am a novice so your not missing anything --
this is probably a very easy question.)
Thanks
|