View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RigasMinho RigasMinho is offline
external usenet poster
 
Posts: 40
Default 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?