Need VBA code to cap only select words

[skyport]

Need VBA code to cap only select words that will be found throughout columns A-F and a list of the select words that the code would look for would be on a separate worksheet named “words2” in column A so that additional keywords could be added on an ongoing basis.

 

[Leith Ross]

Hello Skyport,

Will there be more than one word per cell?

 

[skyport]

Hi Leith, thanks for helping. Yes there would sometimes be more than one word per cell.

 

[skyport]

Does anyone have a solution to this one?