/VBA/Excel vba determine number of elements in a 2D array

Excel vba determine number of elements in a 2D 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 vote232 views2 answers
Open url from vba
VBA
0 vote220 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote209 views1 answer
Open application from vbnet
VBA
0 vote177 views1 answer
Vbide vbproject reference
VBA
0 vote232 views1 answer
Vba simple quote
VBA
0 vote215 views1 answer
Send webhook vbscript
VBA
1 vote221 views1 answer
Excel vba first and last row and column in range
VBA
0 vote234 views4 answers
Vgrive,deb
VBA
0 vote263 views1 answer
How to enter Vbox manage commands
VBA
0 vote229 views1 answer
Vba min
VBA