Macro seems to make entire text string in cells Bold

Hi everyone,

I have the following code:

Please Login or Register  to view this content.

Pretty simple. However, whenever I run the code, if there's even on word that is bold in the cell, then the entire text string in the cell turns bold. How can I stop this from happening? i want to keep the format of the text string the same, only remove and replace the items listed in the code.

Thanks!

Sorry... you can bold the entire cell or nothing..
but you can't only a single character of it separately..

however, you can try following..

Please Login or Register  to view this content.

Don't forget to click *

Hi Vikas,

Thanks for getting back to me. The text in the cell right now already has some words bolded while others are not. What I'm trying to do is keep that specific format from changing. i will try your code. Thanks!

I'm getting an error on the .replace(word,"") line. Saying it expected a =

Okay then try this..
these were the braces which are posing problem...

Please Login or Register  to view this content.

Don't forget to click *