Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a string without knowing position
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i get the last position of a char (space) in a string? | Excel Worksheet Functions | |||
Position in a string | Excel Worksheet Functions | |||
find nth position of a string | Excel Discussion (Misc queries) | |||
Select from first worksheet without knowing it's name | Excel Programming | |||
Auto Select a file not knowing its specific name | Excel Programming |