Reset public arrays

[MetLife]

Hi,

I have a vba program with publicly declared variable arrays.

My program loops around and when it does I need to clear the array and reset all the values to zero.

What is the best way to do this? I notice that even when the program ends, the arrays still hold the values. Shouldn't the arrays be reset to zero at the end of the vba program?

Thanks

 

[dmt32]

Hi
Use Erase statement

Erase MyArray

From VBA Helpfile:

Erase frees the memory used by dynamic arrays. Before your program can refer to the dynamic array again, it must redeclare the array variable's dimensions using a ReDim statement.

Dave

 

[shg]

I notice that even when the program ends, the arrays still hold the values. Shouldn't the arrays be reset to zero at the end of the vba program?

See Help for Understanding the Lifetime of Variables

 

[MetLife]

what help?