How to alphabetize a collection that's already populated

Hi all,

If I have a collection that is already populated and the item and the Key are the same value, how can I alphabetize that collection? I don't want to use the method of putting the values in a worksheet, sorting it, then putting them back into the collection.

For example, I have to get all the unique values in every sheet that is in range P18 so I'm using a collection so each value can only be added to the collection once.

Please Login or Register  to view this content.

At this point all unique values in P18 of every sheet are in the collection. How can I alphabetize that now?

Thank you!

Thanks WideBoyDixon!

That works excellent! Thanks for that!

WideBoyDixon,

Well it works excellent on my computer, but not on another persons computer (which is a laptop that I know nothing about yet, but I'm getting Excel and Windows info)
Anyway, the 2 attached files are the error he gets on his computer. Can you please help me find out why?

I think SortedList requires Framework version 3.5, which is often not available on new computers. They generally have version 4.5 or later. But just install that version and you should be OK.

Artik

Originally Posted by Artik

I think SortedList requires Framework version 3.5

I could swear I remember Microsoft telling us that these kind of dependency problems would cease to exist when they introduced the dotNET "stuff" way, way back.

Thanks you guys!

Well if that's the case, I'm not going to be able to use this solution because I'm not going to be able to go around and check everyone's computers or install anything. It sure works good on mine though. I found another solution, but it separates Capitalized words from non capitalized words so that's not ideal, but I might have to use it.

Thanks again!

If the ASCII character range is enough for you then you can try it:

Please Login or Register  to view this content.

Artik

Re: How to alphabetize a collection that's already populated

1) Add below lines in bold

Please Login or Register  to view this content.

2) Add below sub procedure

Please Login or Register  to view this content.

Thanks Artik and Jindon!

I will be trying these later, just wanted you to know. I will be back with an update either tomorrow or after the weekend (3 day weekend for me ). Thank you very much for your help here!