/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 vote224 views1 answer
Vbnet get file name from path
VBA
0 vote242 views1 answer
Vba pass named range to function
VBA
0 vote241 views1 answer
Enable macros on opening workbook vba
VBA
5 votes264 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote253 views1 answer
Vba sheet hide unhide
VBA
0 vote257 views1 answer
Excel vba set cell value to empty
VBA
0 vote283 views1 answer
Excel vba protect sheet
VBA
2 votes219 views1 answer
Vba array contains
VBA
0 vote249 views1 answer
Excel vba copy range with filter
VBA
0 vote229 views1 answer
How to use if condition in time vba
VBA