What is the code of clsMembers?
RBS
"excel_ez" wrote in message
...
This is just a part of my original code:
Dim myCollection As New Collection
Dim member As clsMembers
Public i As Long
For i = 1 To 3000
Set member = Range(Cells(i, 1), Cells(i, 14))
myCollections.Add member
next
I am trying to create a collection of row within a range. I tried the same
mechanism with simple elements like numbers etc. but I never got past 256
"RB Smissaert" wrote:
Didn't you have a Byte variable anywhere causing the trouble?
Post the code.
RBS
"excel_ez" wrote in message
...
Hi
I tried to create an Excell2003 VB collection with say 1500-2000
members.
But after 256 members are added, the loop continues WITHOUT ANY ERROR
MESSAGE
but no more members are added to the collection
Is it possible that 256 is the limit?
I couldn't find it written down anywhere, but that limit is just too
low.
I was just wondering if any of you knows more about this?