Find specific cell value
 

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.

Find specific cell value
 

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

Sharad

"nathan" wrote in message
...
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.

Find specific cell value
 

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.

--
Regards,
Tom Ogilvy


"nathan" wrote in message
...
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.

Find specific cell value
 

quite simple, thank you.

"Sharad Naik" wrote:

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

Sharad

"nathan" wrote in message
...
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.