is there a way of searching a range of cells, to see if ANY of th
contents of the cell match a string. For example, if cell A1 contain
the words "Pizza, Milk, Bread", and I am only searching for pizza,
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 onl
works if the ENTIRE cell equals my search variable(FVar)? is there a wa
of changing this code to test whether any contents of the cell equal m
search variable?? Thanks for the help!

--
tess45
-----------------------------------------------------------------------
tess457's Profile: http://www.excelforum.com/member.php...fo&userid=1393
View this thread: http://www.excelforum.com/showthread.php?threadid=26218