How do I interpret this array? (VBA Excel)

Question

When stepping through code in Developer mode in Excel I see an array in VBA like so:

arrData(x)(y,z)

Is this a 2-dimensional array (the (y,z) part) stored inside an array (the (x) part)?

How do I access a particular element within the array and test if the value equals something I'm interested in?

If arrData(1)(2,3) = "orange" Then
End If

My above code yields Run-time error '9': Subscript out of range. The max value of x and y is 1, and the max value of z is 100.

If the max value of x and y is 1, don't try to use a 2 for the y value. `arrData(1)(1,3)` — tigeravatar, Jan 21 '16 at 20:22
@Jules not always, but likely. It depends on how the array was filled. It could also depend on how the array was declared. It may be ArrData(1to1) — Scott Craner, Jan 21 '16 at 21:10
Correct, that's why I said by default :). EDIT: to be save use lbound and ubound to check min/max index. — Jules, Jan 21 '16 at 21:44

score 0 · Answer 1 · edited May 23 '17 at 10:27

0

This is called a jagged array. Essentially it is an array inside an array. These can be implemented in VBA (as you discovered) and can be called just like a regular array.

This answer here on SO explains it nicely.

edited May 23 '17 at 10:27

Community

1
1

answered Nov 08 '16 at 16:00

rohrl77

3,277
11
47
73

How do I interpret this array? (VBA Excel)

1 Answers1