| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find specific words in a cell containing a conversation | Excel Worksheet Functions | |||
| How do I find a cell starting with a specific letter? | Excel Discussion (Misc queries) | |||
| Find last cell in a specific column | Excel Programming | |||
| How to find and sub total a specific number of cell above the target cell | Excel Programming | |||
| use find twice to find cell on a specific row | Excel Programming | |||
Linear Mode
