Look at Find in VBA Help.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GreenInIowa" wrote in message
...
Hi,

I have sells which contains states codes, such as NY, CA, IA, etc., and
would like to find those cells containing these codes. I was wondering if
there is a VBA function to test whether the text in a given cell contains,
let say "NY". I just could not find it.

Thanks.