Flushing Memory/Cache Clear:
If you are using user forms then unload them before using them again:
Unload UserForm1
If you are using variables then you have defined them as module or global
level variables. They are not reset until you close and reopen the workbook.
If any variables are used only within a specific routine then define them
there and they will be reinitialized each time the routine is called.
Kevin
|