/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 vote301 views2 answers
Vba remove line breaks
VBA
1 vote296 views1 answer
Add control vb
VBA
0 vote296 views1 answer
How to set location and size of new from vb
VBA
2 votes293 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote288 views1 answer
Excel vba current folder
VBA
0 vote302 views1 answer
Vba check if class implements interface
VBA
0 vote280 views1 answer
Vbnet check if string is only symbols
VBA
3 votes306 views1 answer
Vba http request json
VBA
0 vote313 views1 answer
Excel vba prevent saving workbook
VBA
0 vote288 views1 answer
Visual stuiod not recognising desgined labels
VBA