Run-time error '91: Object variable or with block variable not set 2

[PWD]

Good afternoon. I have spreadsheets with multiple worksheets and my user wants to search for certain names. I start off with this

 MyText = InputBox("Type the text for the rows you want to cut.", "Look for this")

And get down to

  Range("E:E").Find(What:=MyText, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        False).Activate

The trouble is that it falls over at the second consecutive worksheet where nothing matches the find. I've tried a couple of

 If ....Then

to trap & move on but it fails on the first loop (the first 'Find') of the second sheet where nothing matches.

Any ideas?

Many thanks,

Des.

 

[PWD]

Well,

 On Error Resume Next

but not 'Resume' within this context.

Des.

 

[PHV]

Combo, FYI, Resume is the only way, aside from exiting the procedure, to get out of an error handling block, dot.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[combo]

Right! ==>(*)

combo