Find Values in Cell
If i have a cell that has the values - A,C,D
How do I do a find using vba:
Set rngFound = rngToSearch.Find(What:="A", _
LookIn:=xlFormulas, _
LookAt:=xlWhole, _
MatchCase:=False)
That line finds the cells with Just A but i need to also find cells
where A is with other values.
Even the Control+F doesnt find the cell when it has A,C,D in it.
Anyone know?
|