Macro that deletes rows below a certain value

Hello,

I am looking for help in creating a macro that will delete the 42 rows below a cell and the cell itself that contain the following value; (any number) of (any number)



For example a cell containing ; 3 of 18, would be deleted along with the 42 cells (rows) below that. All of the data is in column A.

Any help would be greatly appreciated.

Thanks!

D