Highlight EVERY instance of a word in cells

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.

Please Login or Register  to view this content.

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.

Any help would be greatly appreciated.

Originally Posted by Macdave_19

Lol trying to replicate oracle SQL syntax by an chance?

I think i looked at this a while ago and came up withy noting so it'll intersting seeing how you get on.

Good luck, wish i could help.

Fingers crossed.

PS. Its not my code. I can't take credit for it. Another forum member created it I only changed the array values.