| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to deal with Find when nothing is found
I have this in my Sub.
Cells.Find(what:=LOC, After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate If the string is not found, it runs an error, giving the user the option to debug. How can I have it comeback and say the string was not found and then end the sub? Am I making sense? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND function does not return ZERO when text is not found | Excel Worksheet Functions | |||
| Has anyone made a Deal or No Deal Gamebord | Excel Discussion (Misc queries) | |||
| How to find a row since I found a value in a column? see example | Excel Worksheet Functions | |||
| Find 'Product not found' | Excel Programming | |||
| If no FIND value is found, then a Msgbox to say so and exit sub | Excel Programming | |||
Threaded Mode
