freeing memory... don't understand

[wildcat_2000]

hi all,

i've got something that may look a stupid question...

when i dim an object like this:

Dim MyVar(1000000) as string

then at the end of the project if i want to free it like this:

Set MyVar(1000000) = Nothing

i get a "object still needed error" even though i'm really not using that variable and it has not been declared public...

What am i doing wrong?

thanks,

w.

[beachbum]

hi
Firstly, a million elements is far too small .. lets go for a billion!
Set and Nothing are for objects not for arrays

The correct way is...

At top of form in declarations area
Dim MyVar() As String 'note no number for dynamic array

when u want to use it do...
Redim MyVar(1000000)

and when u want to clear it...
Erase MyVar

Regards
Stuart

[wildcat_2000]

a million, no, a billion thanks ;-)

i do hope this is enough for memory management...

i don't know if i need a million but this number may vary from 10 to 1000000... so i put it up at max, even i know, this does slow down everything...

well if you do have another way to go... ;-)

thanks for your answer!

cheers,
w.

[da_silvy]

You can make it larger at run time if need be

When you fill it, use

ReDim Preserve MyArr(10000)