In case - don't be misled by the 256 limit you can see in Locals or in a
Watch.

Dim i As Long
Dim col As Collection

Set col = New Collection
For i = 1 To 20000
col.Add i, CStr(i)
Next

MsgBox col("20000")

Regards,
Peter T

"Keith" wrote in message
...
thanks for the post, but still does not answer the core question:

I beleive the collection only will hold 256.

an array is different from a collection.


"Gary Keramidas" wrote:

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?