Delete Blank Rows in a pattern
I have a spreadsheet that beginning in Row 6 has data every thrid row
for about 7500 rows. I want to delete all blank rows to the last
filled row. The pattern is such;
Blank
Blank
Data
Blank
Blank
Data
Blank
Blank
Data.............etc
Is there a fast way in code to segregate the blank rows and delete
them all? TIA
Greg
|