I have the below sheet and wish to write macro to delete entire rows that
contain "SME" in category column. The size of sheet will vary as will the
location of the rows within the sheet. I'm guessing I need a relative macro,
but I can't come up with one that works.

A B Category D
xxx xxx PM y
xgy xxx SME z
sss xxx PM y
ccc nnn SME d

Thanks for your help.

dean