Delete rows or Clear contents below a specific word is found in Column A

Hi,
I have an excel file in which i have data for 7000 rows. I only need the data up to a specific row. SO, for that I want to use a macro.

i want to delete or Clear contents below a specific word (which is "Pro Production") is found in Column A.

Please help

Do either of these help?

Clear Contents

Please Login or Register  to view this content.

Delete

Please Login or Register  to view this content.

Delete Entire Row

Please Login or Register  to view this content.