Hey Guys!
Thanks again! Thanks Bry for the explanation.
I'm just pinging back in to the discussion:
I am definitely more accustom to programming with arrays and that was the method that I started out using before I finally folded and decided to post for a bit of help.
If, you had just coded with an array initially, I likely would have said thanks Bry and moved on.
It was the fact that you used the collection that peaked my interest.
Recently, I saw someone bring in data from a stored procedure from SQL and assign that data to a New Collection and I just thought, that was the coolest thing.
So while I have been at VBA for a few years, there are certainly methods I have not touched yet; like New Collections, Class Modules and so on.
I guess that is one of the beauties of programming, there is always more to learn.
I will definitely examine you code closer and see if I can not apply that method with another example.
Now, after The Collection is created, you could then create properties and methods as well to those objects, couldn't you?
Thanks!
Mark