JWColby
jwcolby at colbyconsulting.com
Thu Jan 18 09:58:33 CST 2007
I have always been under the impression that Collections in VBA could hold a maximum of 32K objects. The other day I thought someone said it was actually 65K. I just tested and got to ~500K before I broke out of the code. Does anyone know what the real limitation is? I thought that it had to do with using an integer to index in of no key was specified but that appears to not be the case. John W. Colby Colby Consulting www.ColbyConsulting.com