/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 vote176 views1 answer
Change form background image vb
VBA
0 vote180 views1 answer
Vba extract filename from path
VBA
0 vote169 views1 answer
Vba static variable
VBA
5 votes196 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote172 views1 answer
Convert unix to date vba
VBA
0 vote164 views1 answer
Type excel.application is not defined vb
VBA
8 votes182 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote179 views1 answer
Vba horizontalalignment
VBA
0 vote165 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote182 views1 answer
Vba check if class implements interface
VBA