/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 vote199 views1 answer
Excel text to columns line break
VBA
0 vote260 views1 answer
Vba is integer
VBA
0 vote209 views1 answer
Show unix time in vba
VBA
0 vote194 views1 answer
Type excel.application is not defined vb
VBA
1 vote211 views1 answer
Vb.net get name by Selection Changed
VBA
4 votes196 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote208 views1 answer
Date as number vb
VBA
0 vote193 views2 answers
Excel vba copy paste after last row
VBA
3 votes256 views2 answers
Excel "vba" match last value
VBA
2 votes218 views1 answer
Vba file from path
VBA