View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 236
Default VBA memory allocation

In Java the object doesn't get removed from memory until the Java VM
runs a garbage collector.

It's possible to evoke the garbage collector from Java, but
utilimately the VM has control over the object.

Try this (although I doubt this will help) :

set myCollection=Nothing

The thing about collections is that you often end up using them
globally.

Probably what you need to do is iterate over your collection, set each
member to Nothing, then set the collection to Nothing.