Generally, you code should be designed not to crash, so this shouldn't be an
issue in a working app.

Running the code that originally set the values for the variables should
work again after the crash (if you hit the reset button in the VBE).

--
Regards,
Tom Ogilvy

"Les Gordon" wrote in message
...
I have declared two Public variables to track various data. Eveything
works
well until the systme crashes (in this case, which I will fix, because the
suggesated sheetname has more than 31 characters). Once it crashes the
Public
variables loose their values and can't be reset; closing the workbook
doesn't
help but restarting Excel does. Is this a scope problem; can I fix it in
code?

Regards
--
Les Gordon