Running a partial string formatting macro more than once messes up

[MYazal]

I am trying to run a macro to format parts of the strings in each cell according to different conditions. Each string may contain multiple different formats. The problem is that it works perfectly if I reset the data and run the macro once. If I run it more than that, the unformatted parts of the string, take the formatting of the first character in the cell. I want the unformatted parts to retain whatever formating they had before the macro runs multiple times and not change.

I have attached a dummy file with both a reset and a clean up (the macro I want) button. Just click any cell in "Col 2" for them to appear. Thanks in advance.

[mrice]

The issue appears to be occurring on the line

Please Login or Register  to view this content.

As you have converted to lower case the first time, you don't need to on subsequent occasions

Try this

Please Login or Register  to view this content.

[MYazal]

Thanks, but this partially works. Whenever the initial string's formatting isn't completely uniform and the macro runs, things go haywire and sometimes Excel just needs to quit.

I've attached an updated version to further explain the problem.

[mrice]

Hmmmm....

Might be worth trying putting a DoEvents statement inside your loop to allow Excel to let other processes catch up frequently.