Answers for "vba ubound array 2-dimensional"

excel vba ubound on a multidimensional array

'The VBA UBound() function returns the max index of an array.

MsgBox UBound(vArr)			'<--max index of the first dimension

'There is an optional second argument called rank (that defaults to: 1) 
'that specifies the dimension:

MsgBox UBound(vArr, 2)		'<--max index of the second dimension

'VBA array can have up to 60 dimensions.

'All of the above also applise to the LBound() function.

vba ubound array 2-dimensional

Dim arr(1 To 4, 1 To 3) As Variant
Debug.Print UBound(arr)     ' returns 2
Debug.Print UBound(arr, 1)  ' returns 4
Debug.Print UBound(arr, 2)  ' returns 3