"Adam1 Chicago" wrote in message
...
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


You can define a name similar to the name of your variable and refer to the
value of your variable.

/Fredrik