If I'm missing something, pls lemme know...
intIndex = 1
Dim MyArray() As Variant
ReDim MyArray(1 To 1, 1 To 2)
intIndex = intIndex + 1
ReDim Preserve MyArray(1 To intIndex, 1 To 2)
Last line fails with error #9 - subscript out-a-range
All I'm trying to do is ReDim MyArray(1 To 2, 1 To 2) from its previous setting of (1 To 1, 1 To 2). Shouldn't it be possible to do this?