/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 vote228 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote233 views1 answer
Returns an array from function vba
VBA
1 vote208 views2 answers
Vba string to date
VBA
0 vote261 views1 answer
Excel vba round to whole number
VBA
0 vote270 views1 answer
Vba excel parser xml
VBA
0 vote214 views1 answer
Excel vba remove formatting from cell
VBA
0 vote243 views1 answer
Vba clear collection
VBA
5 votes200 views1 answer
Vba array worksheet.index
VBA
1 vote217 views1 answer
Close form vba
VBA
0 vote226 views1 answer
Excel named range sum
VBA