How can I use VBA code to replace text in one cell with formatted text
from another cell?

Here is an example.

Cell a1 contains text that may include italicized or bolded characters.
The content and format of cell a1 is controlled by the user.

Cell b1 contains text to search for and does not contain character
formatting.

Cell c1 contains the target text, some of which will be replaced. It
does not contain character formatting.

How can I search c1 for the text in b1 and replace it with the contents
of a1 while keeping any formatted characters in a1?

I have no trouble doing the search and replace, but cannot figure out
how to preserve any formatted text.

Any suggestions?

Taxi


--
Taxi Houston
------------------------------------------------------------------------
Taxi Houston's Profile: http://www.excelforum.com/member.php...o&userid=14818
View this thread: http://www.excelforum.com/showthread...hreadid=264496