excelvbadebuggingcollectionsvbe

VBA debugger shows only 256 elements of a collection

I'm working on an Excel macro. Is there an option that the debugger shows all elements like it does with an array?

If not, is the only workaround the storage of my classobjects in an array after inflating the collection?

Solution

  • You could use debug.print and write the output into the immediate window and bypass the limit that way.

    I am almost certain that there is no way to increase that limit, but maybe someone else can give a def. answer on that.