[RESOLVED] Working with Array VBA Excel

[billhuard]

Is there a faster way to find the index of a value contained in an array than looping the entire array and compare the value you want to find to the value of the index???

EX:

For lnCounter = 0 To UBound(TheArray, 2)
    If MyValue = TheArray(lnCounter,1) then
        MyIndex = lnCounter
    End If
Next lnCounter

Thanks