not sure if this is relevant, but this is excel 2003

Worksheet arrays Limited by available memory. Also, arrays cannot refer to
entire columns. For example, an array cannot refer to the entire column C:C or
to the range C1:C65536. However, an array can refer to the range C1:D65535
because the range is one row short of the maximum worksheet size and does not
include the entire C or D column


http://office.microsoft.com/en-us/ex...992911033.aspx


http://office.microsoft.com/en-us/ex...738491033.aspx
--


Gary


"Keith" wrote in message
...
I am using excel 2000 and trying to add 500 elements to a collection.

The collection will only add 256 elements. Is there a limit to the numer of
elements?

What about in excel 2003?