Resetting Global Variables

[Krusher]

How can I reset public variables? Or, how do I simply tell VBA to "recompile" everytime the user executes the macro? Thanks in advance.

K

 

[SkipVought]

Hi,

Write a procedure that initializes the variables in question. Then call this procedure any time you want them "reset".

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}