LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell formula that will give back the address of the cursor? Byron Excel Worksheet Functions 1 February 25th 10 03:04 AM
To give back ground colour for entire row on certain condition pol Excel Discussion (Misc queries) 6 May 22nd 09 11:41 AM
How to give back a value, based in another table? Rodrigo Excel Discussion (Misc queries) 0 June 11th 08 03:19 PM
Excel should be able to give back the colorcode of a cell via celi Bart Schouw Excel Worksheet Functions 13 January 7th 05 09:12 PM
too many external links give "Not Enough Memory" error lothario[_67_] Excel Programming 0 January 13th 04 04:03 AM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"