Delete row contents if keyword is found in Column E

[bonsaitrees]

Hi,

I'm looking for some code that will delete the row it is in if the word 'Homework' is found anywhere in column E.

Thank you

[jeffreybrown]

Try

Please Login or Register  to view this content.

Change sheet name to match

[YvorL]

Hi!

For search us '.Find' , and for deleting the row '.EntireRow.Delete' .

[bonsaitrees]

Thanks for the solution

[jeffreybrown]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.