Statement Erase For Free

The Erase statement can appear only at procedure level. This means you can release arrays inside a procedure but not at class or module level. The Erase statement is equivalent to assigning Nothing to each array variable.

VBA Code to get the length of Array (one-dimensional array): Press Alt+F8 to popup macro window. Select ? oneDimArrayLength? and Click Run button. Compute Number of Rows, Number of Columns using UBound and LBound function. Multiply by noOfRow and noOfCol variable to get Number of elements in multi-dimensional array.

The Erase Function is used to reset the values of fixed size arrays and free the memory of the dynamic arrays. It behaves depending upon the type of the arrays.

Examples to use VBA Redim Statement Then, follow the below steps to apply ?ReDim.? Step 1: Create a macro name first. Step 2: Declare an array name as a string. Step 3: Now, use ?Redim? and assign the array size.

You need to use the ?Erase? statement to clear an array in VBA. Add the keyword ?Erase? before the name of the array that you want to clear but note that all the values will be reset from the array.

VBA Code to get the length of Array (one-dimensional array): Press Alt+F8 to popup macro window. Select ? oneDimArrayLength? and Click Run button. Compute Number of Rows, Number of Columns using UBound and LBound function. Multiply by noOfRow and noOfCol variable to get Number of elements in multi-dimensional array.

The Get procedure automatically returns that data type. You can specify any data type or the name of an enumeration, structure, class, or interface. If the Property statement does not specify returntype , the procedure returns Object .