i went through a range of 20k+ records to add unique items to a collection
and it always stopped at 256. there are 322 in the list. i just used an
advanced filter for now, to copy the unique values and add them to an array.

so, it doesn't really matter, i was just curious and i thought i had used
collections with more than 256 elements, but wasn't sure.

--

Gary Keramidas
Excel 2003


"Nigel" wrote in message
...
Not to my knowledge. I have larger collections working, not sure what is
or controls the upper limit?

--

Regards,
Nigel




"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
i can't seem to remember, can a collection only hold 256 elements?

--

Gary Keramidas
Excel 2003