I need to determine whether a cell contains a particular string of text, what
is the best function or way of doing this in my macro?

For Example:
I want to know whether cell A1 contains the text "AUA", if it does then I'm
going to execute some code, if it doesn't then I'm going to execute some
other code. I was trying to use the Range.Find method but I had a lot of
trouble with it.

Thanks.