Steve

Refer the below link to get a better understand of variables and scope.
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

If I have code that prompts the user for some sort of input, is it possible
to have store the value of the variable so the next time the macro runs, it's
available?