On Sat, 19 Dec 2009 15:37:01 -0800, OssieMac
wrote:

The following is the usual method of using find. You don't need on error.
You set a range variable to the found cell and if it is nothing then it is
not found but if it is Not nothing then it is found.

OssieMac,

Thank for the more usual method! When I first ran into the need to
handle the situation I tried to implement this method but I'm still
enough of a beginner that I couldn't do it right so I treid the "on
error" method and still failed with that! I look forward to the day
when I'll be more capable like you and many of the other experts
lurking in this group!


John Keith