You are correct. Myself and one other have really been trying to standardize everything as we get it but there is still a lot out there that we won't be able to touch until it comes across our desk. That's why we try whenever possible to find ways to identify these with the tools we have so we can correct them to weed them out slowly. Which you have been a great help in as well. On a side note, if I wanted to exclude the content in tables from the search how could I modify the code to do that? I thought I managed to find some code but I can't seem to make it work. Then I remembered I'm not looking for MS Word code since this is running in Excel, so I didn't quite know what to search for.