highlite find cell?

[dani1]

hi experts!

is any body knows that if we use find option in excel so highlite found cell?

is it possible?

 

[VoG]

Change the bit in red

Set tempcell = Cells.Find(What:=sTxt, After:=Found, LookIn:=xlValues, lookat:=xlPart)

 

[XL&ME]

Vog,

Thank you very much for showing me how to modify the macro to find partial words. This is a tremendous help to me!