/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 vote165 views1 answer
Visual basic msdos
VBA
0 vote183 views1 answer
Power query M substract minimum value of column -dax
VBA
1 vote203 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote190 views1 answer
Test if form is open vb
VBA
1 vote155 views1 answer
How to do error handling in access vba
VBA
0 vote180 views1 answer
Vba table header name
VBA
31 votes236 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote179 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote174 views1 answer
VBA Sort RossetaCode
VBA
1 vote158 views1 answer
Vba delete array element
VBA