Array Index / Item position ?

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

re: Array Index / Item position ?

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(value, key).

Rich

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

re: Array Index / Item position ?

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

--

Terry Kreft


"Rich P" <rpng123@aol.comwrote in message
news:455a36c1$0$10300$815e3792@news.qwest.net...

re: Array Index / Item position ?

midlothian@gmail.com wrote: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(left(tempString, InStr(tempString, "/CT/")),
"/")) - 1

but ... why would it be important?

re: Array Index / Item position ?

On 14 Nov 2006 12:51:56 -0800, midlothian@gmail.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.