Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Unique item to Collection
I was pretty sure I knew how collections worked, but why do I get a run time
error (457) with this macro? Doesn't the On Error Resume Next trap that error? XL2000, Win98SE. Sub test() Dim theColl As New Collection theColl.Add "me", "me" On Error Resume Next theColl.Add "me", "me" On Error GoTo 0 End Sub Thanks. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
unique item remover | Excel Discussion (Misc queries) | |||
Adding Unique Items to a Collection | Excel Discussion (Misc queries) | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Removing an Item From a Collection | Excel Programming |