Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Trapping the Find method
Hi everyone,
I'm using the Find method in VBA to return the row containing specific text. Trouble is if the text isn't in the column I'm searching I just get a VBA error. I've tried using : If IsError(<Find syntax) Then... but that doesn't seem to work. Anyone have any ideas about error trapping this thing? At the moment I'm using On Error Resume Next, but I don't really want to! TIA big t |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Trapping from WSH | Excel Discussion (Misc queries) | |||
error trapping | Excel Discussion (Misc queries) | |||
Error Trapping | Excel Programming | |||
Trapping the "Can't find project or library error" | Excel Programming | |||
error trapping | Excel Programming |