How to merge two collections in VBA?

Question

What's the most efficient way to merge two collections together in VBA, so that I have a 3rd Collection containing all of the items from the first two?

Answer 1

Read this article, which compares For vs For Each loops when iterating arrays, vs. when iterating object collections.

Bottom line:

• Use For loops to iterate arrays.
• Use For Each loops to iterate collections.

So, iterate your collections with For Each loops, and in these loops Add the items to your 3^rd collection.