delete rows when column has specific word(s)

AB33 Thanks very much!!! it works

Originally Posted by AB33

Try the attached.
The code was initially written for a loop code ,hence you see lots of commenting on some of the lines.