neat fix to a gross line of code?

Can you upload a workbook?

I don't understand the reason why you need to sort the collection etc...

Originally Posted by jindon

Can you upload a workbook?

I don't understand the reason why you need to sort the collection etc...

I managed to get this all working.

The "sort collection" part, was so I could have everything alphabetical, and also have similar entries next to each other in the collection, so I could removed them and result in a unique list.

I had to do a second "sort collection" that made sure that the longest strings where searched for first and then the shortest, to prevent accidently having my information go into the wrong category (if the string of the shorter is also found within the longer string, would result in errors).

Anyways, thanks for your help!

Jimmy