From my own test I find out that turning screen updating off and on takes about 15ms (tested in C# via Excel Interop).
Keep that on mind if you will execute anything which would take less time.
Highlight Color Index = wd Red Codes = Mid(my Range, 2, Len(my Range) - 2) With o Doc.
Execute Replace:=wd Replace All, Forward:=True End With End If For k = 1 To o Doc.
Execute Replace:=wd Replace All, Forward:=True End With Else: my Range.