How to Clear an Array

[Cyberdude]

Is there a simple way in VBA to clear an array of all values?

[Tommy]

Redim with no preserve keyword?

[Bob Phillips]

Erase myArray

It not only removes values, if it is a dynamic array, it releases it which means that it has no bounds.

[Cyberdude]

Erase myArray

It not only removes values, if it is a dynamic array, it releases it which means that it has no bounds.

Does that mean I would have to ReDim it? What are the consequences of the erase? Can I still use it?

Reset. I looked it up in Help. Thanx.

[MWE]

Does that mean I would have to ReDim it? What are the consequences of the erase? Can I still use it?

Reset. I looked it up in Help. Thanx.
The impact depends on what type of array is being erased. VBA help does a pretty good job explaining what happens with its example. You can still use "fixed" arrays as before. You will need to redim dynamic arrays to reallocate space.

[from VBA Help]
Erase Statement Example

This example uses the Erase statement to reinitialize the elements of fixed-size arrays and deallocate dynamic-array storage space.


' Declare array variables.
Dim NumArray(10) As Integer ' Integer array.
Dim StrVarArray(10) As String ' Variable-string array.
Dim StrFixArray(10) As String * 10 ' Fixed-string array.
Dim VarArray(10) As Variant ' Variant array.
Dim DynamicArray() As Integer ' Dynamic array.
ReDim DynamicArray(10) ' Allocate storage space.
Erase NumArray ' Each element set to 0.
Erase StrVarArray ' Each element set to zero-length
' string ("").
Erase StrFixArray ' Each element set to 0.
Erase VarArray ' Each element set to Empty.
Erase DynamicArray ' Free memory used by array.