How can I get back the key of collection object?
Best regards
Gabriel

Signature
gabch
Robin Hammond - 20 Mar 2006 13:52 GMT
Gabriel,
Ridiculous as it sounds, I don't think you can.
Robin Hammond
www.enhanceddatasystems.com
> How can I get back the key of collection object?
>
> Best regards
> Gabriel
Tom Ogilvy - 20 Mar 2006 16:07 GMT
You can't get a list of keys for elements in a collection unless they match
the item stored in the collection.
Maybe a dictionary object from the scripting runtime would be better.

Signature
Regards,
Tom Ogilvy
> How can I get back the key of collection object?
>
> Best regards
> Gabriel
Chip Pearson - 20 Mar 2006 16:10 GMT
Unfortunately, there is no way to read the keys of a collection.
You might consider using a Dictionary object.

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
> How can I get back the key of collection object?
>
> Best regards
> Gabriel
paul.robinson@it-tallaght.ie - 20 Mar 2006 17:40 GMT
Hi
I tend to hold the key, if i need it, as part of the object in the
collection. So a collection of text strings would now be two element
arrays - the first one the string and the second one the key.
regards
Paul