Look at help for the worksheet functions Find and Search

--
Regards,
Tom Ogilvy


"tess457" wrote in message
...

is there a way of searching a range of cells, to see if ANY of the
contents of the cell match a string. For example, if cell A1 contains
the words "Pizza, Milk, Bread", and I am only searching for pizza, I
still want to select that cell?

Selection.FormulaR1C1 = "=OR(RC[-3]={""" & FVar & """})"

I am using the above code to filter my cells right now....but this only
works if the ENTIRE cell equals my search variable(FVar)? is there a way
of changing this code to test whether any contents of the cell equal my
search variable?? Thanks for the help!!


--
tess457
------------------------------------------------------------------------
tess457's Profile:
http://www.excelforum.com/member.php...o&userid=13938
View this thread: http://www.excelforum.com/showthread...hreadid=262187