collection and limit

  • Thread starter Thread starter --== Alain ==--
  • Start date Start date
A

--== Alain ==--

Hi,

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

thanks a lot,

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


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
 
Alain

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

Richard
 
It's not the collection that's limited, but the Watch window. I've
added well more than 256 items to collections, only to be tricked by
what displays in the watch window.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of objects in a collection 4
Limitation to Collection Object 4
maximum number of members in a collection 8
collection question 6
execute assigned data validation in vba? 11
Problems in copying a Collection to another and removing elementsfrom two Collections 6
Collection Object, 255 item limitation 4
Class module and a lot of records 1

Back
Top