Clearing an array in VBA

[JoeS01]

What is the quickest and easiest way to clear the contents of single dimension and multidimension arrays?

 

[dk]

Hi,

Try this:

Erase YourArrayName

HTH
Dan

 

[SidBord]

Erase has the advantage that it also releases memory.

 

[JoeS01]

With thanks

Thanks for this advice.
Erase statement actually sets the value of each cell to zero, where I have a numeric array.
Do you know of any statement like this that sets all the cells to empty or null?

 

[Jon Peltier]

Erase is for an array in VB/VBA.

To clear a range of cells:

Range("A1:D10").Clear

 

[dk]

Re: With thanks

Thanks for this advice.
Erase statement actually sets the value of each cell to zero, where I have a numeric array.
Do you know of any statement like this that sets all the cells to empty or null?

Hi,

I assume that you are using fixed dimension arrays rather than declaring a dynamic array i.e.

Fixed
Dim MyArray(1 to 10) As Long

Dynamic
Dim MyArray() As Long
Redim MyArray(1 to 10) As Long

Erase will re-initialise fixed arrays but completely delete dynamic arrays. You can get more details by looking up the erase statement in the VBA help file.

Cheers
Dan