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

 

[Norman Jones]

Erase myAyy

Or even:

Erase myArr

 

[SiriS]

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

Sir