delete all blank rows in a table
 

I need to delete all of the blank lines in the table.

delete all blank rows in a table
 

You can sort ascending or descending and the blanks will rise to the top or
fall to the bottom.

Or, just filter the column for blanks (DataFilterAutofilter), and select a
custom value of blanks and delete the visible rows.


Regards,
Ryan---

--
RyGuy


"marcia2026" wrote:

I need to delete all of the blank lines in the table.

delete all blank rows in a table
 

See your other post for code

Stick with one thread for continuity.


Gord Dibben MS Excel MVP


On Fri, 11 Jul 2008 14:22:13 -0700, marcia2026
wrote:

I need to delete all of the blank lines in the table.