Find keyword and delete the rows below and above

Yes There is only one keyword.And I want to delete the rows below and above.
in the sample after applying macro I should only have the rows between 6 and 33(after macro it should be like that after macro.xlsx

Originally Posted by patel45

ther'is only one row with the selected keyword in one sheet ?