Flushing Memory/Cache Clear:

  • Thread starter Thread starter Ardy
  • Start date Start date
A

Ardy

Hello All:
I have a general question, It seem that when I run some codes,
doesn't matter what it is, Once I modify it in the same session, it
seem that the previous version to the modification is still running.
I suspected this so to confirm it I have added letters to the given
messages and I still get the previous message, it almost seems that
the original code is stuck in the memory. If this assumption is
correct how would I clear memory.

____________ Sample _____________
If Some code Then
Do something
Else
MsgBox "Message!"
Some code to flush the memory
Exit Sub
End If
 
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
 
This is your third post of the same question. Have you looked at the other
answers? Did you try what was recomended? Please try to stick with just one
thread...
 
This is your third post of the same question. Have you looked at the other
answers? Did you try what was recomended? Please try to stick with just one
thread...
Click to expand...

Jim:
It was not my intent to do so, Google has been having problems with
the posts showing up, users don't see the posts thinking it didn't
go, so naturally they try to post. this problem came abt around late
16th. currently I am trying All suggested solutions......
Sorry for the multiple post
 
Back
Top