Originally Posted by macropod

There are doubtless some good books and tutorials around but, since I don't use any of that stuff, I can't recommend any. All my VBA expertise is self-taught, though studying code that others have posted on different forums over the years has been a great help, too.

Yes, that's typical macro-recorder code. The macro recorder's not much smarter than a box of rocks. For an idea of what's possible with Find/Replace coding, see: https://www.msofficeforums.com/140662-post2.html