Retrieve the index from an object in a collection

[Tom Berling]

I would like to retrieve the index of a particular object in a collection,
so that I may reference it as coll.item(index). Any ideas on how to do that?

For Each sec In sectors.sectors 

   If sec.rank(0) = 1 Then  
         
'now I would like to extract the index of the object of interest for further 'reference - something in line with the following      
      index = sectors.sectors.item(sec)           

   End If
Next sec

 

[RoryA]

Why not loop with a counter instead of a For Each?

 

[Tom Berling]

Thanks for the quick reply!