/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 vote191 views1 answer
Get month number from month name vbnet
VBA
5 votes199 views1 answer
Excel vba low word from Long Integer
VBA
0 vote181 views1 answer
Vbnet add axis labels to chart
VBA
1 vote194 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote174 views1 answer
Add items to combobox vb.net
VBA
0 vote196 views1 answer
Vba first cell in range
VBA
0 vote182 views1 answer
Vbs write file
VBA
1 vote174 views1 answer
Excel vba compare 2 rows
VBA
2 votes171 views1 answer
Date format for ms chart vb.net
VBA
0 vote206 views1 answer
Vba character ascii code
VBA