T
tess457
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!
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!