/VBA/Excel vba determine number of elements in an array

Excel vba determine number of elements in an array

'Since VBA arrays can have ANY integer value (from -2147483648 to 
'2147483647) for the lower index in the range for a rank,
'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 vote150 views1 answer
VBA Loop through recordset
VBA
0 vote191 views1 answer
How to call gcd in vba
VBA
0 vote157 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote150 views1 answer
Vba like with wildcard
VBA
0 vote175 views1 answer
Excel vba protect shapes
VBA
5 votes180 views1 answer
Excel vba how to unit test vba code
VBA
0 vote114 views1 answer
Vbide vbproject reference
VBA
0 vote149 views1 answer
Vbnet line graph smooth lines
VBA
0 vote149 views1 answer
Excel vba disable copy paste
VBA
0 vote151 views2 answers
Excel vba close without saving
VBA