VBA Deselect Formatting on Specific Text String

Hi, I wonder whether someone could help me please.

I'm using the code below to deselect bold formatting to a particular text string in this case "(exc. C&I)".

Please Login or Register  to view this content.

The problem I have is that although the desired text is correctly re-formatted , so is the text after this text string and I'm not sure why.

I just wondered whether someone may be able to look at this please and let me know where I've gone wrong.

Many thanks and kind regards

Chris

Hi @romperstomper, thank you very much for taking the time to come back to me with this and for correcting my code. It's exactly what I was after.

All the best and kind regards

Chris

Hi @romperstomper thank you very much for taking the time to help me further it's truly appreciated.

Kind Regards

Chris