Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect when Find returns nothing?
Hi all
How do I detect when the following code returns nothing, meaning when no match is found? I need to when no match is found and then take different action. Please share with me the code syntax to do this? Thanks. Cells.Find(What:="xyx", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate Ben -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect when Find returns nothing?
See Schollar's response in:
http://groups.google.com/group/micro...06311c55e74647 -- Gary's Student "Ben" wrote: Hi all How do I detect when the following code returns nothing, meaning when no match is found? I need to when no match is found and then take different action. Please share with me the code syntax to do this? Thanks. Cells.Find(What:="xyx", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate Ben -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find function returns the #VALUE! error value | Excel Discussion (Misc queries) | |||
Find method Returns | Excel Programming | |||
how to find returns for lump sum & yearly investments | Excel Worksheet Functions | |||
How to find returns in cells | Excel Worksheet Functions | |||
Find Next in a selection, how to stop it when it returns to the fi | Excel Programming |