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?

Change

LookAt:=xlWhole

to

LookAt:=xlPart


In article .com,
"RigasMinho" wrote:

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?