/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

1 vote355 views1 answer
Excel vba array remove first
VBA
12 votes484 views1 answer
Excel vba write string to text file
VBA
0 vote355 views1 answer
Vba file chooser
VBA
0 vote343 views1 answer
Vbnet check if number is even or odd
VBA
0 vote381 views2 answers
S yyyy-MM-dd em vb net
VBA
1 vote369 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote369 views1 answer
Excel last used row
VBA
7 votes371 views1 answer
Vba array declaration
VBA
0 vote349 views1 answer
Search in richtextbox vb.net
VBA
0 vote335 views1 answer
Visual basic msdos
VBA