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