maximum size of collection

[wladqe]

Hello;
i have one question:
what is maximum size of collection in vba ?
The Debugger shows only the 256 items. Is size only 256 items ? or debugger shows only 256 items and size is without limits ?

 

[Ruddles]

The Debugger only shows the first 256 items: http://stackoverflow.com/questions/3136507/vba-collection-maximum-size.

What happens when you cycle through the collection using For Each?

 

[wladqe]

I dont know whats you exacly think , but when I use for each , hope that works correctly , so I have one more question , can you help me pls
i need insert condition into for cycle, can you help me pls ?

condition = 50

For Each l In ccc
    If l > condition Then
        l = l
        With aaa
        .Add Item:=l
        End With
    Else:
        l = l
        With bbb
        .Add Item:=l
        End With
    End If
    
Next

ccc is variant
aaa and bbb is collection

 

[Ruddles]

I don't really know much about collections - I hardly use them. I'm sure someone else will be able to help you though.