ReDim preserve gives "subscript out of range"

[bertjeiv]

My script runs through the array to look if a certain value already exists in faultArray(x,1) and if it does then faultArray(x,2) gets incremented. If it does not exist in they array I redimension it to add another set of values to it with this line:

ReDim Preserve faultArray(1 To UBound(faultArray, 1) + 1, 1 To 2)

I get Run-time error '9': Subscript out of range...

thanks fot the help

 

[Norie]

You can only redim preserve the last dimension of an array.

 

[RoryA]

if you use Preserve, that is. And you can only alter the upper bound.

 

[bertjeiv]

ok thanks then I know what to do!
thank you for the help!