Quote:
Originally Posted by Thefirstfish`
For some reason, having tracked changes on makes the above code behave oddly in some situations (e.g., one function changes "1+1" to "1 + 1" with tracked changes off, but with tracked changes on the output is "11+ ").
|
Yes, that's a known 'Track Changes' behaviour. You could have the macro toggle & restore the 'Track Changes' state.
Quote:
Originally Posted by Thefirstfish`
The only thing I still can't automate is to remove the percentage sign in text such as "20%-40% when an en dash is used instead of a hyphen. However, I have about 150 functions in the macro so having only one misbehaving isn't bad.
|
That's easily resolved by changing
.Text = "([0-9])%(-[0-9])"
to:
.Text = "([0-9])%(?[0-9])"