View Single Post
 
Old 11-04-2021, 07:56 AM
JingleBelle JingleBelle is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2020
Posts: 26
JingleBelle is on a distinguished road
Default

Hey, Andrew.


Thank you for adjusting the code for me. There is NO way I would have come up with that on my own.


It works like charm, and I appreciate the tip about the search term being in the first and second row. Of course, that had not occurred to me. I don't think that will be an issue.


The macro works as I wanted; however, it did fail when it encountered a table with a vertically merged cell. I had not considered that obstacle either. I think, though, in my notes somewhere or in some code I picked up on this forum, there is a way to avoid or skip over those tables. With any luck, I will be able to cobble the two together and get it to work. Having said that, I may be back.


Thank you, again, for your willingness to help me. I appreciate it very much.
Reply With Quote