Array Index / Item position ?

[midlothian]

Hello
Is there a way to get the index of an item in an array? For instance,
if I have:

MyArray = Array("NY","CT" ,"TX","NM")

....can I see what position CT is in the array?
Thanks

[Rich P]

THe only way to get an index from an array is to loop through the array
until you match the desired value. YOu can use a collection object
which uses keys collObj.Add(val ue, key).

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Terry Kreft]

.... but even with a collection you can't find the index of an item without
looping through the collection.

--

Terry Kreft
"Rich P" <rp*****@aol.co mwrote in message
news:45******** *************** @news.qwest.net ...

THe only way to get an index from an array is to loop through the array
until you match the desired value. YOu can use a collection object
which uses keys collObj.Add(val ue, key).

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Lyle Fairfield]

mi********@gmai l.com wrote:

Hello
Is there a way to get the index of an item in an array? For instance,
if I have:

MyArray = Array("NY","CT" ,"TX","NM")

...can I see what position CT is in the array?
Thanks

If it were important I'd hack something up along these lines (it would
need some more work):

Dim MyArray As Variant
Dim tempString As String
MyArray = Array("NY", "CT", "TX", "NM")
tempString = "/" & Join(MyArray, "/") & "/"
Debug.Print UBound(Split(le ft(tempString, InStr(tempStrin g, "/CT/")),
"/")) - 1

but ... why would it be important?

[Tom van Stiphout]

On 14 Nov 2006 12:51:56 -0800, mi********@gmai l.com wrote:

How did you get these values into this variant array? Perhaps
something can be done at the source.
If not, just loop using a For Each loop. On small arrays like this the
ugly n/2 performance is negligible.

-Tom.

>Hello
Is there a way to get the index of an item in an array? For instance,
if I have:

MyArray = Array("NY","CT" ,"TX","NM")

...can I see what position CT is in the array?
Thanks