View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
timothy[_2_] timothy[_2_] is offline
external usenet poster
 
Posts: 3
Default Collection Object, 255 item limitation

Hi

It appears I have run into a 255 item limitiation in VBA with the
"Collection" object. Anyone have any ideas?

This is what I have defined as <Code:

< Public gcolE_Defs() As New Collection

then when I execute the following code

< gcolE_Defs(i).ADD Item:=oED, key:=CStr(iCount)

and the iCount is beyond 255 or 256 it stops adding items to the
collection.

Anyone have any ideas?????

Timothy Marks