Found?, then delete entire rows. Not found end sub

Hello All,
Would someone be able to create a macro that can find all instances of a particular text (in this case "Kings and Queens") and then delete entire rows once found? In the one workbook, rows 39 and 85 should be deleted. However, the same macro should end if the text is not found. I have attached two workbooks, each showing the two different scenarios (i.e. found or not found). The macro should NOT scan both workbooks at once. One macro should work on each workbook separately. The macro should scan cells C1:C300 for the text.

If you have any questions, please do not hesitate to contact me.

Thanking you all in advance,

Andrewstupendo

How about

Please Login or Register  to view this content.

Thank you so much for your help, Fluff13. It works perfectly!

Glad to help & thanks for the feedback