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