excel - vba: clear entire array - Stack Overflow

You can either use the Erase or ReDim statements to clear the array: Dim threeDimArray(9, 9, 9), ...

stackoverflow.com