Thanks for the replies all.

For #2, its actually not "Distr", it is "District" and it is only in column
A. So I would want it to go: search in column A for the word "District"; when
found, delete the row it is in; repeat until no more found.

How they became blue?... this is an export from a web database. The export
adds all districts to one worksheet. They put that blue header row and a few
blank rows at the beginning of each district. We don't care about separating
them by districts so we just want all of the data to be contiguous. And, we
can't properly filter if those header rows are in the way.

If you could say "start the macro on row 5 and delete any row where you find
the phrase "Facility Name" and don't repeat" that would do it as well, as
"Facility Name" is one of the headers that I doubt would ever appear as real
text in the worksheet.

Thanks again,
Jeff