Reporting of Colections in Locals WIndow (Excel VBA (all?))

Topic

New Reply

You can run code like this:

Sub Test()
    Dim Coll As New Collection
    Dim lArray(1 To 500) As Long
    Dim x As Long
    For x = 1 To 500
        lArray(x) = x
        Coll.Add x
    Next
End Sub

o create an array of 500 values and a collection of 500 values. If you put a break on the “end sub” you can stop the code and look at the variables in the locals window. The Array shows all 500 items, but the items in the collection only show 256. Further investigation (dumping it to an array, a range, or checking the items, etc) demonstrates that the collection contains all 500 items, it just does not seem to show them all in the locals window.

Is this a known bug in XL97? Does it still exist in other versions? Is it really an issue that needs to be worried about?

Steve

Reply | Quote

Replies

I can verify that it behaves the same way in 2K.

Reply | Quote

I can verify that it behaves the same way in 2K.

Reply | Quote

And the same in Office XP (2002) VBA too – this is not surprising, because Office XP and Office 2000 both use Visual Basic 6.3.

Reply | Quote

And the same in Office XP (2002) VBA too – this is not surprising, because Office XP and Office 2000 both use Visual Basic 6.3.

Reply | Quote

Same in ’03, Steve.

Some time back Charlotte pointed out to me in the VBA Forum that she has had occasional problems with:

For Each Object in Collection

and she avoids those problems (and following her advice, so do I) by using

For lCounter = 1 to Collection.Count
Collection(lCounter).whatever

Wonder if the issues are related.

Reply | Quote

Don’t know if it is related, but I could use for each to put all 500 items into the spreadsheet without issue, so in this example it did not stop at 256.

Steve

Reply | Quote

Don’t know if it is related, but I could use for each to put all 500 items into the spreadsheet without issue, so in this example it did not stop at 256.

Steve

Reply | Quote

Same in ’03, Steve.

Some time back Charlotte pointed out to me in the VBA Forum that she has had occasional problems with:

For Each Object in Collection

and she avoids those problems (and following her advice, so do I) by using

For lCounter = 1 to Collection.Count
Collection(lCounter).whatever

Wonder if the issues are related.

Reply | Quote