So I'm relatively new to macros and have mostly constructed the one I'm using by downloading and tweaking it. It works great, but there's one more thing I'd like it to do that I'm having trouble with. Here's the code:
It opens a word document, finds all instances of a word from column A, and replaces them with whatever's in the corresponding row in column D. What I want it to do is also highlight specific words in the Word document that come from column D. These will be in the form of a number and the letter M (6m, 12m). I want it to highlight every time the number's over 12. So wherever it puts 12m, 13m, 14m, and so forth in the Word doc, I want it to be highlighted. I'd prefer if this happened as a function of the existing Excel macro as opposed to building a Word macro specifically for this purpose. Thoughts?
Bookmarks