Removing Items from a Collection (2003)

Topic

New Reply

Hi all,
I’m playing around with Class Modules for the first time, and was wondering:
The class I’m using contains data about a worksheet and it’s formatting and used range. I’ve got a number of these new class objects in a collection. I would like to loop through these objects several times. With each loop, some sheets will be determined to have no more problems to be fixed, and should be removed from the collection.
Is there a simple way to remove these objects from the collection while looping with For Each, or is it best to just use something like For x = colMyCollection.count to 1 step -1 and remove by item number?
Hope this was clear. Thanks!

Reply | Quote

Replies

I think the latter: looping with the item number. I have found that the “each” may get “confused” when things are deleted from (and even added to ) the collection during the looping.

Steve

Reply | Quote

Thanks, Steve – that makes sense.

Reply | Quote