Day: December 2, 2013

Collections of Collections in VBA

In many situations using collections of one kind or another is very useful. Once in a while, you even want to go another step and use collections of collections. Just as there are several types of collections in VBA, there are several ways you can use collections of collections. All of them have benefits and drawbacks. I'll provide a summary of them here.

Nested collection types

The three types of nested collections I'll cover in this article are as follows:

Read more