Infinite loops occurring in find and replace functions in word macro

macropod · #1 04-06-2017, 07:18 PM

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])"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Macro for Find and Replace, Inserting logo in Ms-Word.	Aswinraj	Word VBA	1	06-05-2016 04:33 PM
Find and Replace Macro Need	djpemberton	Word VBA	2	05-04-2016 07:53 PM
Find and Replace Macro	amparete13	PowerPoint	3	03-11-2014 05:29 AM
Word VBA Macro to Find and Replace based on the Alt Text of an Image	bennymc	Word VBA	1	01-27-2014 04:23 PM
Find and Replace Macro - A Better Way	Tribos	Word VBA	0	10-08-2008 03:22 AM