"clear multidimensional array

[magmo]

Hi

I have this code....

Dim arrMyArray(,) As Integer    ' No bounds yet.
ReDim arrMyArray(iCounter, 6)          ' Give it bounds.

If I only want to "clear" the values that the array has been assigned to it, how would I do that?


Regards

 

[AnonGod]

Correct me if I'm wrong, but I don't believe the .clear method works on multidimensional arrays.

To just clear the data and keep the bounds, see if this is what you are looking for.
-Andrew

dim row, col as integer
row = ubound(arrMyArray,2)
col = ubound(arrMyArray,1)

redim arrMyArray(col, row) ' keeps bounds
redim arrMyArray(-1)       ' does not keep bounds
' in both cases, data is cleared.