Hi Todd,

Todd Huttenstine wrote:
Thanks. I figured out what was going on with my code. I
found out that in order to remove items from a collection,
you must use the .remove method. I was saying .remove
(variable) and it was not working. It kept leaving 1 item
in there. When you remove an item in a collection, the
index resets to 1. I did not know this, so instead I
used .remove 1 and then it worked.

Another option is to destroy the collection (Set TestCollection=Nothing).
I've found it to faster, not to mention less code.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]