Thanks for looking at my question. I think that I may have stumbled on to a workable answer with the following:
It actually starts at the third row in my sorted spreadsheet, finds the first cell that has data in column C (my sort data column) goes up one row, and then deletes all of the blank rows that were sorted above my actual data but below my header rows (1,2 & 3).![]()
Range("c3", Range("c3").End(xlDown)).Offset(-1, 0).Select Selection.EntireRow.Delete
Thanks again
Bookmarks