Not able to redim 2 dimension array Subscript out of range

Question

I had an 2 dimension array, (1 to 406, 1 to 8)

when I try to redim and perserve the value

 ReDim Preserve arr(1 To UBound(arr()) + 1, 1 To 8)

it pop out error Subscript out of range, what actually Im doing wrong?

score 0 · Accepted Answer · edited May 23 '17 at 10:31

0

You can only ReDim Preserve the last dimension in a multidimensional array with VBA, which is a great feature.

There are some workarounds to this issue described in this answer.

edited May 23 '17 at 10:31

Community

answered Oct 18 '13 at 07:27

mattboy

ouch, guess thats the only solution for this – Se0ng11 Oct 18 '13 at 07:30
1

Link to other SO posts are not answers. You should have ideally marked this question as duplicate rather than re-answering it :) – Siddharth Rout Oct 18 '13 at 07:44

1 Answers1