VBA Multidimensional dynamic array?

Question

I don't know how to create a dynamic multidimensional Array. At present i have declared my array as Dim fArr(0 To 4, 0 To 9). it is always (0 to 4) in one dimension but other dimension (0-9) is always variable so how do i do it?.

I populate my array like this example

     Select Case fTyp
         Case Is = "A"
             fArr(0, aRow) = j
         Case Is = "B"
             fArr(1, aRow) = j
         Case Is = "C"
             fArr(2, aRow) = j
     End Select

Thanks

Possible duplicate of Dynamic Multi-Dimensional array problem — user23573
– user23573, Commented Oct 28, 2015 at 19:49
just before your loop redim farr(4,x) as variant x is the variable that you use in your for loop for arow = 0 to x. so what ever you have in place of x in your for loop put that same thing in for x in the redim. Just like @AlexWeber stated. — Scott Craner
– Scott Craner, Commented Oct 28, 2015 at 20:03
Just an unrelated side note, wouldn't Case "A" be simpler than Case Is = "A"? — Mathieu Guindon
– Mathieu Guindon, Commented Oct 28, 2015 at 21:33

Alex Weber · Accepted Answer · 2015-10-28 19:38:11Z

3

You can use a ReDim to create a dynamic amount of dimensions in an array. Firstly, you must dim your array in the following way:

Dim fArr() as String ' Or whatever datatype you want

Then, when you're ready to enter the dimension of the Array, you use a ReDim.

ReDim fArr(4, VBAVariable) as String 'Or whatever datatype you want

You can ReDim multiple times. Check out this article for extra features that ReDim has.

answered Oct 28, 2015 at 19:38

Alex Weber

4482 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shan Over a year ago

at present it is like this

Collectives™ on Stack Overflow

VBA Multidimensional dynamic array?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related