View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
big t big t is offline
external usenet poster
 
Posts: 40
Default 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