Hi,
I am looking to highlight every instance of a word (or series of words) in an Excel spreadsheet. I've searched through the forums and found a lot of excellent information regarding my issue but I can't quite get it to work.
The below code works to a point.
It searches for instances of the words in the array called Fnd and highlights them in another color. These words are 'select ', 'update ' and 'insert '. My issue with this code is that it only seems to highlight the first instance of each word in each cell. I need it to highlight all intances of the word and in some cases there will be more than one instance of each word per cell.Please Login or Register to view this content.
Any help would be greatly appreciated.
Bookmarks