Thanks, Paul. This is what happens when I test the code against a test table:

The word "scanned" appears 29 times in one column of the table; your code says there is 1 occurrence

The phrase "TO BE SCANNED" appears 21 times in one column of the table; your code says there is 1 occurrence

Two other searches for words that occur once each in the same and other columns
had no hits with this code.

Not sure why this is - does the 'If .Duplicate.InRange(Rng)' code have something to do with it? I need a count of all search hits.