Releasing arrays?
 

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: http://www.excelforum.com/member.php...fo&userid=7995
View this thread: http://www.excelforum.com/showthread...hreadid=494563

Releasing arrays?
 

Hi SiriS,

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

Try:

Erase myAyy


---
Regards,
Norman


"SiriS" wrote in message
...

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:
http://www.excelforum.com/member.php...fo&userid=7995
View this thread: http://www.excelforum.com/showthread...hreadid=494563

Releasing arrays?
 

Erase myAyy

Or even:

Erase myArr

---
Regards,
Norman


"Norman Jones" wrote in message
...
Hi SiriS,

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

Try:

Erase myAyy


---
Regards,
Norman


"SiriS" wrote in
message ...

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:
http://www.excelforum.com/member.php...fo&userid=7995
View this thread:
http://www.excelforum.com/showthread...hreadid=494563

Releasing arrays?
 

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

Siri


--
SiriS
------------------------------------------------------------------------
SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995
View this thread: http://www.excelforum.com/showthread...hreadid=494563