Erase Statement

Erases the contents of array elements of fixed size arrays, and releases the memory used by arrays of variable size.

Syntax:

Erase syntax

Erase array1 [, array2 [,...]]

Parameters:

array list - A comma delimited list of arrays to be erased.

Example:

Sub Erase_Example
    a = Array(1,2,3) :  b= Array("z","y","x") : c=Array(a,b)
    Erase a, c(Ubound(c)) ' b and c(0) are unchanged
    Erase b, c(0) ' everything gets cleared
End Sub

Dim or ReDim statements

Array or DimArray functions

Lbound and Ubound functions

Please support us!