/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 vote344 views1 answer
Vba dictionary length
VBA
0 vote370 views1 answer
Enable macros on opening workbook vba
VBA
5 votes372 views1 answer
Xl vba double quotes in string literal
VBA
0 vote366 views4 answers
How to continue formula in below line in vba code
VBA
3 votes407 views1 answer
Vba continue for each loop
VBA
0 vote406 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote335 views1 answer
Check if program is running vbnet
VBA
0 vote368 views1 answer
Vbnet add axis labels to chart
VBA
0 vote353 views1 answer
Sendkeys vba selenium
VBA
2 votes356 views2 answers
Vba code to remove duplicates from a column
VBA