A loop to delete rows based on condition

I am trying to have a loop look at column O, and if the word "Duplicate" is there, then delete the row. Loop until isempty(activecell) = true


Here is my code to which I am not having any success

Please Login or Register  to view this content.

thanks for any help