/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 vote177 views1 answer
Enter into cells data grid view
VBA
1 vote187 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
1 vote207 views1 answer
Find and replace textbox
VBA
0 vote178 views1 answer
Vba len variant
VBA
0 vote185 views1 answer
Vba run command
VBA
1 vote186 views1 answer
How to put a gridpain in a vbox
VBA
0 vote168 views1 answer
Remove frist letter from string vbnet
VBA
5 votes202 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote174 views1 answer
Excel vba select multiple shapes
VBA
0 vote178 views1 answer
Excel vba disable copy paste
VBA