max number of elements

[crptcblade]

Is there a way to determine the total number of elements in an array?

Like if I did this:

Dim stuff As Variant
stuff = Split(Text1.Text,",")

that turns stuff into an array. Is there a way to return how many elements are in that array??

Use the UBound() function.

MsgBox "There are " & UBound(stuff) & " number of elements in this array"

[gwdash]

If it's 2-10, though that will return 10.

Use UBound() - LBound()