Delete entire row when specifc word is typed into a cell in that row

Hi would anyone be able to help, I have been looking for an answer to this issue for ages but no avail. I want to have VBA search the document, after the user clicks the button on the userform. To find any cells that contain the word "Scrapped", then delete that entire row

Thank you in advance

Dom Brown

Maybe:

Please Login or Register  to view this content.