There is no way to hold on to the variables short of storing them in a
worksheet somewhere. When the execution is halted the memory that stores the
variables is automatically cleared. In the grander scheme of things if you
just had an error though you can not gurantee that the values in your globals
would be correct anyways so clearing them is really no great loss. What you
want to do is to write bullet proof code with a robust error handler to
gracefully handle anything that is thrown at it. That will keep you from
getting to the debug screen in the first place.

--
HTH...

Jim Thomlinson


"Mike Archer" wrote:

Hello - When VBA code chokes and the user selects the debug button, all
global variables are cleared. It there a way to keep the global variable
values or an option other than global variables?
--
Thanks,
Mike