software

Hi,

when using arrays in a VBA sub, is it necessary to explict release
memory at the end of procedure?

If so, how to do this? I have tried
Set myArr = nothing
but it did not work.

Thank you,
Siri--
SiriS
------------------------------------------------------------------------
SiriS's Profile: www.excelforum.com/member.php...foamp;userid=7995
View this thread: www.excelforum.com/showthread...hreadid=494563Hi SiriS,

gt; If so, how to do this? I have tried
gt; Set myArr = nothing
gt; but it did not work.

Try:

Erase myAyy---
Regards,
Normanquot;SiriSquot; gt; wrote in message
...
gt;
gt; Hi,
gt;
gt; when using arrays in a VBA sub, is it necessary to explict release
gt; memory at the end of procedure?
gt;
gt; If so, how to do this? I have tried
gt; Set myArr = nothing
gt; but it did not work.
gt;
gt; Thank you,
gt; Siri
gt;
gt;
gt; --
gt; SiriS
gt; ------------------------------------------------------------------------
gt; SiriS's Profile:
gt; www.excelforum.com/member.php...foamp;userid=7995
gt; View this thread: www.excelforum.com/showthread...hreadid=494563
gt;
gt; Erase myAyy

Or even:

Erase myArr

---
Regards,
Normanquot;Norman Jonesquot; gt; wrote in message
...
gt; Hi SiriS,
gt;
gt;gt; If so, how to do this? I have tried
gt;gt; Set myArr = nothing
gt;gt; but it did not work.
gt;
gt; Try:
gt;
gt; Erase myAyy
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;SiriSquot; gt; wrote in
gt; message ...
gt;gt;
gt;gt; Hi,
gt;gt;
gt;gt; when using arrays in a VBA sub, is it necessary to explict release
gt;gt; memory at the end of procedure?
gt;gt;
gt;gt; If so, how to do this? I have tried
gt;gt; Set myArr = nothing
gt;gt; but it did not work.
gt;gt;
gt;gt; Thank you,
gt;gt; Siri
gt;gt;
gt;gt;
gt;gt; --
gt;gt; SiriS
gt;gt; ------------------------------------------------------------------------
gt;gt; SiriS's Profile:
gt;gt; www.excelforum.com/member.php...foamp;userid=7995
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=494563
gt;gt;
gt;
gt;

Hi,
Thank you, the Erase fucntion is just what I need!

Siri--
SiriS
------------------------------------------------------------------------
SiriS's Profile: www.excelforum.com/member.php...foamp;userid=7995
View this thread: www.excelforum.com/showthread...hreadid=494563