Reset Collection
 

Permission error on a combo often arises because it is set to a worksheet
range. What does the code look like?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Minitman" wrote in message
...
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

Reset Collection
 

Hey Bob,

Thanks for the reply.

I just sent the code with my last reply.

Please, feel free to take a peak at it.

-Minitman


On Thu, 27 Jul 2006 13:21:51 +0100, "Bob Phillips"
wrote:

Permission error on a combo often arises because it is set to a worksheet
range. What does the code look like?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Minitman" wrote in message
.. .
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