/VBA/Excel vba determine number of elements in a 1D array

Excel vba determine number of elements in a 1D 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

25 votes474 views3 answers
String to date vb
VBA
0 vote305 views1 answer
Vba declare 64-bit ptrsafe
VBA
1 vote307 views1 answer
Excel vba get ordinal number from cardinal number
VBA
1 vote303 views1 answer
If inputbox cancel vba
VBA
0 vote336 views1 answer
Excel named range sum
VBA
0 vote330 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote324 views1 answer
How to add line graph vb net
VBA
1 vote303 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote318 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote313 views1 answer
Default host vbox address
VBA