View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin Jones[_2_] Kevin Jones[_2_] is offline
external usenet poster
 
Posts: 8
Default 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