Does anybody know a way of scanning an excel workbook

[finglem]

Does anybody know a way of scanning an excel workbook for a text string and if the string is found, then making the cell(s) in which the text string resides bold or coloured. Can this be done in code?
Any help much appreciated. Thanks

 

[dyarwood]

Try something like this in your code

Cells.Find(What:="WHAT YOUR LOOKING FOR", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
Selection.Font.ColorIndex = 3
Cells.FindNext(After:=ActiveCell).Activate
Selection.Font.ColorIndex = 3

This colours the selected cell text red.

You could use a loop to go throught until the findnext property was false.

This might help. let me know

dyarwood