Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reset Collection | Excel Programming | |||
Collection Key | Excel Programming | |||
The Pictures Collection | Excel Programming | |||
Collection | Excel Programming | |||
Reset New Collection | Excel Programming |