| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Problem- Using Find Function
I see, thanks.
Tom Ogilvy wrote: *Find doesn't produce an error when the item searched for is no found. Code that assumes the item will always be found produces the error cells.Find("ZX2HZ") doesn't produce an error cells.Find("ZX2HZ").Activate produces an error because it assumes the string is found. -- Regards, Tom Ogilvy -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Method problem in Excel VBA.... | Excel Worksheet Functions | |||
| find function in EXCEL | Setting up and Configuration of Excel | |||
| Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
| Problem in VBA with function FIND(... | Excel Programming | |||
| Problem with Find function | Excel Programming | |||
![Chris_Fifield[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
