I haven't found anything really on Memory management, but this is the
situation I am in.

I an nth level array of arrays. That means that I may have as little as an
array of arrays, or as much as an array of arrays of arrays of arrays, etc...

My current usage of the application results in something like 60,000 array
cells being created. It takes no more than 5 minutes to create, read, and
store data to all of the necessary cells, however....

When the program finishes, I currently am not doing anything to free up the
memory. Excel (VBA) "takes care" of it. This process is taking about 30
minutes to destroy all of the data.

How can I free up the memory in a faster fashion? My thoughts are these:
1. Go to the bottom of each array and set the data = nothing, and then if
the array has more than one item, redim the array to be of size 1.

Ultimately ending up with a single array item. that will take a very short
amount of time for VBA to clear up.

2. Some method recommended by someone here.

My concern with my first method is that the memory will still be allocated
and that my efforts to remove each item will not have freed the memory to
make the final closure of the program any faster.

Any ideas? I do not have access to more robust programs like Visual Basic,
C, or C++.