Finding a string in another string"

[danny2000]

Hi
Does anyone know how to find text string in a range of cells.

I am thinking of using a For each next loop and a If then statement to search for a sring in the words in a range of cells.
eg For each cell in selection
If cell.value contains "word" when some cells might containg words like cars, buildings, wording etc I would hope it would find the word "wording" because it contains "word". is there code or a function which can do this?
Any examples would be great because I don't know how to start this.

I'm specifically looking for VBA code not excel spreadsheet formula's.

Thanks.

[dominicb]

Good morning danny2000

What version of Excel are you using? The best thing to use is InStr, but I think it's only available from 2002 onwards. Select a range, at least one of which contains the word "Excel" and run this macro. It will report each occurance and where it was found :

Please Login or Register  to view this content.

HTH

DominicB

[mudraker]

Instr is available in Excel 97
InStrRev is not Available in Excel 97. It was made available in Excel XP or 2000

[dominicb]

Hi mudraker

Instr is available in Excel 97
InStrRev is not Available in Excel 97. It was made available in Excel XP or 2000

Ahaaa, that's what I was thinking of. Thanks for clearing that up.

DominicB