/VBA/Excel vba determine number of elements in an array

Excel vba determine number of elements in an array

'Since VBA arrays can have ANY integer value (from -2147483648 to 
'2147483647) for the lower index in the range for a rank,
'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 vote146 views1 answer
Type excel.application is not defined vb
VBA
1 vote146 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote99 views1 answer
Vba select file in folder
VBA
0 vote158 views1 answer
Vba array dimensions
VBA
0 vote154 views1 answer
Vba collection contains
VBA
0 vote164 views1 answer
Vba check if class implements interface
VBA
2 votes143 views1 answer
Vba uppercase first letter of each word
VBA
0 vote153 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote151 views1 answer
Internet explorer reference vba
VBA
0 vote157 views1 answer
Excel vba linter
VBA