I am trying to delete several words from my file but because two words are similar it deletes both. i.e. if I have PEARS, APPLES AND RED APPLES I only want to delete PEARS AND APPLES but keep all rows containing RED APPLES and the header row.
Could an expert help me with VBA code to do this please. .
Thanks in advance