Do you give memory back?
 

Hello

I have some fairly long procedures. In order to handle and analyse
information, I Dim a number of Variant variables in order to "funnel down"
to the key data.

In terms of good programming in VBA, is it necessary, advisable, or
beneficiary to Redim the arrays to (1,1) after they have been useful but no
longer necessary?

Thanks!

W

Do you give memory back?
 

Unless you arrays are very large, you won't see much benefit by
releasing their memory. However, if you want to do this, and your
arrays are dynamically allocated, use the Erase statement to free
the array's memory.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"cogent" wrote in message
...
Hello

I have some fairly long procedures. In order to handle and
analyse
information, I Dim a number of Variant variables in order to
"funnel down"
to the key data.

In terms of good programming in VBA, is it necessary,
advisable, or
beneficiary to Redim the arrays to (1,1) after they have been
useful but no
longer necessary?

Thanks!

W