VBA - What variable types should be manually unloaded at the end of a macro

[dumitrudan608]

Hi,

I'm trying to make myself a cleaner coder, and hopefully write code that does not slow down every time I run it.

Can anyone help me with a list of variable types that need to be set to nothing or unloaded from memory manually at the end of a macro?

Thank you,
Daniel

 

[jasonb75]

Anything that is declared as Static or Public, which is no longer needed. Everything else should automatically unload when the procedure ends.

 

[RoryA]

It depends on their scope. If they are local to the procedure they are used in, they will be cleared at the end anyway, so you don't need to do anything. If they are module level or public, and you don't need them stored, then clearing them is advisable.