>i checked it out but could not find what i was after. no membership :)
>
>so i take it there is no easy answer to what is better to use between an array and a collection.
There are too many factors to consider to take the right decision between using an array or a collection (and other solutions too such as an in-memory recordset) that we can't tell which is the best. Each one has its own pros and cons.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com