delete all blank rows in a table

's Computer Specifications

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

's Computer Specifications

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 (Data>Filter>Autofilter), 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.

's Computer Specifications

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
<(E-Mail Removed)> wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete Blank Rows when Pivot Table included on sheet	Joyce	Microsoft Excel Programming	3	23rd Mar 2010 03:04 PM
Access counts blank rows in Excel rows as records in linked table	Linkerbink	Microsoft Access External Data	1	14th Nov 2009 05:37 PM
Delete all Blank Rows from data table	Shazi	Microsoft Excel Programming	3	25th Jun 2008 10:19 PM
Referencing a table with blank rows without creating extra rows ?	ZMAN	Microsoft Excel Discussion	4	28th Aug 2006 02:03 PM
Delete blank row only if 2 consecutive blank rows	=?Utf-8?B?QW15?=	Microsoft Excel Programming	2	21st Oct 2004 05:24 PM