Faheem Mitha
Faheem Mitha
Programming language:VBA
2021-03-17 00:46:00
0
Q:

excel vba ubound on a multidimensional array

ALi
ALi
Code: VBA
2021-09-20 23:38:50 
'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.
2

Tags

Related

New to Communities?

Join the community