Variables don't get lost over time by default. It think you would need to
identify why your variables are being lost. Is it a simple scoping problem
or do you have code that runs that uses END (End by itself).

--
Regards,
Tom Ogilvy


"BrianG" wrote:

I have created a purchase order form automating many functions using
VBA in Excel97. One problem I seem to be having is that when users
take a long time to file out the form they end up with a runtime error
caused be the loss of variables. How can I ensure all variables remain
defined until the user exits the worksheet?

--
BrianG