Solved: How many substrings returned by Split() ?

[RonMcK]

Hi, All,

Is that an easy way to determine how many elements are in the Array returned when I use Split() ?

Or do I need to resort to something like this?
i = 0
On Error GoTo Next_step
Do While myArray(i) <> ""
i = i + 1
Loop
Next_step:
On Error GoTo 0


Thanks,

[Kenneth Hobs]

Use lbound() and ubound() to find the lower and upper boundary limits. Of course Split() makes the lbound() to be 0 by design.

[Bob Phillips]

You can also use this



Dim myArray As Variant
Dim aryItem As Variant


myArray = Split("1,2,3,4,5,6", ",")
For Each aryItem In myArray
Debug.Print aryItem
Next aryItem

[RonMcK]

Bob and Kenneth,

Thank you very much for your answers. They both help expand my knowledge of this wee beasty, XL.

Thanks,