Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
This may seem really easy but it has elluded me for a while. I'm trying to figure out the correct syntax to capture an error when a collection key is not part of the collections contents, ie. if not colActiveCollection("NoSuchKey") IsNothing then .... end if The problem is that "NoSuchKey" is not in the collection. So it returns an Object Error and not Nothing. So how can I check the container without having to iterate over the entire collection looking for a match? I'm sure that the answer is below simple, so sorry for having to post such a simple question. Paul. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Correct Syntax | Excel Discussion (Misc queries) | |||
Correct VBA syntax | Excel Discussion (Misc queries) | |||
Can't get this syntax correct, please help. | Excel Programming | |||
ListBoxes - correct syntax | Excel Programming | |||
What is correct syntax for a CommandButton? | Excel Programming |