[RESOLVED] get size of a variant

[lplover2k]

how to get the size of a variant...

e.g.

dim item as variant
item=split(text1.text,",")

i want to loop through all elements found in item and print them

edit:

ok i tried

for each s in item
  msgbox s
next

it seems to work

[DigiRev]

Declare it as a string.

Dim item() As string
 
item() = Split(Text1.text, ",")

Then you can use UBound() to get the upper bounds of the array.

Arrays start at 0.

[lplover2k]

ok thanks

[MartinLiss]

Now that we've helped you, you can help us by pulling down the Thread Tools menu and clicking the Mark Thread Resolved button which will let everyone know that you have your answer. Also if someone has been particularly helpful, or even particularly unhelpful, you have the ability to affect a their forum "reputation" by rating their post.