/VBA/Excel vba determine number of elements in a 1D array

Excel vba determine number of elements in a 1D array

'Since VBA arrays can have any integer value for the base element,
'the only sure fire way to determine how many elements is in the array
'is to calculate the value:

MsgBox UBound(Arr) - LBound(Arr) + 1		'<--for elems in 1D array

MsgBox UBound(Arr, 1) - LBound(Arr, 1) + 1	'<--for rows in 2D array
MsgBox UBound(Arr, 2) - LBound(Arr, 2) + 1	'<--for cols in 2D array

Source: academy.excelhero.com

Similar codes

1 vote175 views1 answer
Excel vba first and last row and column in range
VBA
1 vote181 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote179 views1 answer
Excel vba hide columns
VBA
0 vote184 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote190 views1 answer
For each item in folder outlook vba
VBA
0 vote212 views1 answer
How to call gcd in vba
VBA
0 vote201 views1 answer
Vba change active sheet
VBA
1 vote176 views1 answer
Excel vba close form escape key
VBA
0 vote185 views1 answer
Vba keep command window open
VBA
0 vote179 views1 answer
Excel vba range contains
VBA