On Sat, 2 Aug 2003 at 11:11:14, Tom Ogilvy (Tom Ogilvy
) wrote:
Once you have help open, go to the answer wizard, type in find and hit the
search button. The second entry was the find method and selecting that
gives you what you want.

I've never noticed that tab before - many thanks

Find does not raise an error when the target string is not found. So you
can do

Dim rng as Range
set rng = Worksheets(1).Range("B9:Z26").Find(what:=sTarget, ... other args
... )

if not rng is nothing then
msgbox "Found at " & rng.Address
else
msgbox "Not found"
End if

Cool - many thank to you and Chip for your answers
--
Mike