Originally Posted by gmayor

You have a mix-up with missing variables and incorrect variable types.
Note that it is good practice to add Option Explicit to the top of your modules, which will make it easier to spot such issues.
Your code doesn't read values from either workbook for use in the search. You need to read the values from the worksheet you want to reference into an array in place of the fixed array in the code at
https://www.msofficeforums.com/word-...ding-list.html then loop through the values. I posted code showing how to do this at https://www.msofficeforums.com/word-...ont-style.html