VBA using ubound on a multidimensional array

Question

Ubound can return the max index value of an array, but in a multidimensional array, how would I specify WHICH dimension I want the max index of? For example ``` Dim arr(1 to 4, 1 to 3) As Variant ``` In this 4x3 array, how would I have Ubound return 4, and how would I have Ubound return 3?

Accepted Answer

```
ubound(arr, 1) 
```

and

```
ubound(arr, 2) 
```

VBA using ubound on a multidimensional array

Solution

Problem