/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

0 vote176 views1 answer
Nested if else in vb.net
VBA
0 vote182 views1 answer
Excel vba formatconditions positive
VBA
0 vote182 views1 answer
Vba static variable
VBA
3 votes180 views1 answer
Extract the nth word from a text string
VBA
4 votes166 views2 answers
Vba array length
VBA
5 votes197 views1 answer
Excel vba last byte from INTEGER
VBA
1 vote154 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote184 views1 answer
Vba check if class implements interface
VBA
1 vote186 views1 answer
Vba login website
VBA
0 vote168 views1 answer
Vba declare 64-bit ptrsafe
VBA