LinkBack URL
About LinkBacks
i have the following that prints the item in a collection:
how can i print the key from the collection. probably simple but i have searched for and not found an answer on the web.
Please Login or Register to view this content.
thoughts?
i have the following that prints the item in a collection:
how can i print the key from the collection. probably simple but i have searched for and not found an answer on the web.Please Login or Register to view this content.
thoughts?
any help for printing the key from a collection?
Administrative Note:
We don't expect you to bump threads more than once in 24 hours - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
sorry Ali, will do in the future.
Thank you.
UntestedPlease Login or Register to view this content.
No es posible. You can't retrieve the key by item (it could be a one-to-many mapping), and you can't iterate the keys.
Entia non sunt multiplicanda sine necessitate
I should add that when I need to do this, I skip storing a key for the item and store instead a {'key', item} pair:
That allows you to retrieve the 'key' by index (e.g., col.Items(n)(0)), but you still can't retrieve 'key' by item, because it can still be one to many:Please Login or Register to view this content.
What's the key associated with Item = 1?Please Login or Register to view this content.
Last edited by shg; 04-12-2019 at 12:29 PM.
@shg, thanks for that input. acceptable solution. printed out the entire range with the following code:
Please Login or Register to view this content.
You're welcome.
You could also use a Dictionary instead of course.
Rory
I use both, but collections are great for their ability to be accessed by index -- like when using them as a stack, or for an insertion sort.
Last edited by shg; 04-12-2019 at 10:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks