Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba ubound on a multidimensional array

Excel Hero answered on April 4, 2020 Popularity 5/10 Helpfulness 10/10

answer excel vba ubound on a multidimensional array

excel vba ubound on a multidimensional array

Comment

'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.

Popularity 5/10 Helpfulness 10/10 Language vb

Source: academy.excelhero.com

Tags: excel multidimensional-array vba

Link to this answer
Share Copy Link