/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 vote134 views1 answer
How to use if condition in time vba
VBA
0 vote140 views1 answer
WGET FTP
VBA
1 vote141 views1 answer
Excel vba force recalculation
VBA
0 vote123 views1 answer
Remove frist letter from string vbnet
VBA
0 vote132 views1 answer
Vba border weight
VBA
3 votes146 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote130 views1 answer
Get current year vb
VBA
2 votes137 views1 answer
Vba round number
VBA
-1 vote160 views1 answer
How save excel through visual basic
VBA
0 vote133 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA