Search a word and highlight

Hi,
I have this code and would like to modify little bit with your help. Here is what i want to do:
1)I would like to search each cell in every column in the entire worksheet. The code currently searches only in column A and i would like to expand it in the entire sheet.
2) I need only to search and highlight if it finds the list of words that i specified like the word "BT" or "BTG" But the problem with this code is that it finds and highlights any word that contain the words "BT" or "BTG". For instance, it finds like this word "BTGL" or "BTA" but i want only to find the words that i specify in my list. I would really appreciate if you can help me with this. Thank you so much.

Please Login or Register  to view this content.

Hello karinos57,

You need to change a the search value LookAt from xlPart to xlWhole if you want to match the whole word and not just part of the word. See the code in blue below...

Please Login or Register  to view this content.

Sincerely,
Leith Ross