/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

1 vote235 views1 answer
Excel date to unix timestamp
VBA
0 vote221 views1 answer
Style percent not found vba
VBA
0 vote263 views1 answer
Group controls programmatically vb
VBA
0 vote235 views1 answer
Vba static variable
VBA
0 vote240 views1 answer
Vba apostrophe chr
VBA
0 vote253 views1 answer
Vba copy file
VBA
0 vote256 views1 answer
Windows Forms dark title bar
VBA
6 votes249 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote225 views1 answer
Excel VBA web scraping
VBA
0 vote241 views1 answer
How to carry text to the next line in a label in vb.net
VBA