Dear Sharad,
Thank you very much. I need exactly this.
But there is a small problem.
After replacing the text in part, this macro applies the new font t
the whole cell. New font should be applied only to the replaced tex
leaving the original fonts same for the original text.

I hope I am not asking too much.

Thank you again.
Regards,
Raina

--
Rain
-----------------------------------------------------------------------
Raina's Profile: http://www.excelforum.com/member.php...fo&userid=1550
View this thread: http://www.excelforum.com/showthread.php?threadid=27075