Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't trap error when checking for keys not in Collection
Hello,
For some reason when i try to remove a key from a Collection where that key hasn't been added yet, i cannot trap the error when it occurs within an error handler. All i get is a error dialog box that pops up that says "Invalid procedure call or argument" the code snippet is as follows: On Error GoTo ERR_HANDLER myCollection.Remove ("key1") .. .. .. ERR_HANDLER: ..code here does not get executed when "key1" does not exist in myCollection. How i can trap this error and continue processing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Options in UserForms Collection | Excel Programming | |||
Trap whether it was TAB or arrow keys etc | Excel Programming | |||
Error Trap | Excel Programming | |||
Collection Object Keys | Excel Programming |