View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default 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