Removing Line Gaps in Larger Tables

Using Column C since that column has data on every row we want to keep:

Please Login or Register  to view this content.

Nice code JB, very crisp.

brocko, in column E assuming your tables with 4 columns are columns A to D insert

Formula:

Please Login or Register  to view this content.

and drag the formula down.

Stick an auto filter on, anything in column E with a zero is a line with blank cells in all column, delete visible cells once filtered by zero.

This is essentially what JB has written in VBA.

VBA is pretty easy to use:

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.


=============

A non-vba version of this same idea.

1) Highlight column C
2) Press Ctrl-G to open the GOTO window
3) Click on the SPECIAL button
4) Select Blanks and click OK (all blank cells are now highlighted)
5) Press the keys Alt-E-D to open the DELETE window
6) Select Entire Row and click OK

The shaded areas indicate where I have done work with your worksheet.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.