Originally Posted by gmayor

Another approach would be as follows. Name the column of Words (without empty cells and omitting the header row if any) as WordList. Then run the following to highlight the listed words. Change the value of strWorkbook as appropriate.


The Excel range is read into an array (without opening Excel) and that array is interrogated to get the words.