Find specific cell value

[Guest]

Hello,

I have two cells. One cell contains the text "dollar pop". The other
contains the text "pop". I am attempting to use the "Find" method to find
the cell that contains "pop". However, it finds "dollar pop" (the location
of this cell is before "pop").

How can I find a cell that matches an exact text value ("pop"), not a cell
that contains the search text plus possibly other text in addition ("dollar
pop")?

Thank you.

 

[Sharad Naik]

..Find(What:="pop", LookAt:=xlWhole)

Sharad

 

[Tom Ogilvy]

Use the arguments to the find method. In this case the Lookat argument:
set rng = Cells.Find("pop", Lookin:=xlValues, _
.Lookat:=xlWhole, MatchCase:=False)

See excel vba help on the find method of the range object for details.

 

[Guest]

quite simple, thank you.

..Find(What:="pop", LookAt:=xlWhole)

Sharad