Reset Collection
"Minitman" skrev i en meddelelse
...
Greetings,
Norman Jones helped me with a neat trick using a Collection to remove
duplicate entries from a range. I works great - for the first range -
after that it keeps giving a permission denied error. I think it
might have something to do with the method of resetting the
collection.
Anyone know the best way to load a ComboBox with the contents of a
collection and then reset the collection to fill the next ComboBox?
Any help is much appreciated.
TIA
-Minitman
Set MyCollection = Nothing
--
Best regards
Leo Heuser
Followup to newsgroup only please.
|