Macro that deletes rows below a certain value

Will there be any other entries in column A that follow the format '? of ?'

Dom

No that is the only time- it happens at each page break in a report

I just re-read your question and I want to correct my response- yes it appears at every page break in the report, which is contained in column A....so it wil go 1 of such and such.....a few rows down from there will be 2 of such and such, and so on...