Releasing arrays?

[SiriS]

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

[Norman Jones]

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" <SiriS.20adqz_1134994501.231@excelforum-nospam.com> wrote in message
news:SiriS.20adqz_1134994501.231@excelforum-nospam.com...
>
> 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
>

[Norman Jones]

> Erase myAyy

Or even:

Erase myArr

---
Regards,
Norman


"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:%234BvCeJBGHA.2356@tk2msftngp13.phx.gbl...
> 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" <SiriS.20adqz_1134994501.231@excelforum-nospam.com> wrote in
> message news:SiriS.20adqz_1134994501.231@excelforum-nospam.com...
>>
>> 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
>>
>
>

[SiriS]

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

Siri