View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default collection and limit

I am beginning to wonder if Alain is a real person or a virus.

"RichardSchollar" wrote:

Alain

How are you creating your collection? Can you post the code you have?

Richard


--== Alain ==-- wrote:
It's a simple collection with 21000 records...nothing special

Peter T wrote:
Hi,

I have a collection object and it seems limited to 256 items.
How is it possible to increase this limit ?


Sub test()
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")

End Sub

Is there something special about your particular collection

Regards,
Peter T