Returning Allocated Memory

[StevenM]

Please Login or Register  to view this content.

How does one return allocated memory once one is done with it?

Steven Craig Miller

[Paul]

Hi Steven,

I'm no master of arrays and memory, however you can wipe them by using Erase at any point in the code, e.g.

Please Login or Register  to view this content.

From some brief reading, it appears all other variables (other than objects) release their memory once the scope has changed or the macro ends. Objects should be cleared by setting them to Nothing

Please Login or Register  to view this content.

[StevenM]

Thanks! That is what I needed!