Kre30a: You will have to run macro for each sheet. In each sheet, select all the cells that you want the macro to check for the words and run the macro.