/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 vote356 views1 answer
Make all controls in an area not visable vb
VBA
0 vote349 views1 answer
Vba option button selected
VBA
31 votes485 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote345 views1 answer
Vb net check if file exists
VBA
-1 vote337 views1 answer
For i in range vba
VBA
0 vote373 views2 answers
VB
VBA
0 vote379 views1 answer
Vba excel parser xml
VBA
0 vote355 views1 answer
Vba collection contains
VBA
0 vote350 views1 answer
Replace spaces with underscores vbnet
VBA
1 vote364 views1 answer
Vba format string as cash
VBA