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
|