View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Select a string without knowing position

WIA,
Use the "InStr" function
Jim Cone
San Francisco, USA

"Who I Am"
wrote in message
oups.com
I want to find a string (word) in every row of a range; whenever I find
it, I activate it, and do someting, and move on to next row, until I
touch all rows.
The position of the word in a cell is not fixed, so I cannot use LEFT
or RIGHT

Please help