Deleting rows with blank cells

[Batman]

How do I delete rows that contain blank cells in an Excel Worksheet?

 

[Peo Sjoblom]

Select the range, press F5, special and select blanks, press Ctrl and minus
(dash), select entire row

 

[Batman]

I have four columns of data, some of the cells are blank, how do I delete
those particular rows?

 

[Peo Sjoblom]

Thank you is hard to say? Use either shift left or up

 

[Batman]

I'm sorry - no offence meant - but I don't think you understand, when I
select all 20 000 lines of data and press F5, blah, blah...all it selects is
the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the
columns there are intermittent blanks, the adjacent cells still have data,
but I want to delete the whole row anyway, data, blank cell, and all...

please help I have a project due in 12 hours...thanks

 

[Gord Dibben]

Select just the column with intermittent blanks the follow Peo's F5 etc.


Gord Dibben Excel MVP

 

[Batman]

I need to delete the ROW, not just the blank, thanks anyway

 

[Gord Dibben]

Assume Column C has intermittent blanks.

Select Column C by clicking on the header. That's the rectangle at top with
the letter "C" in it.

F5>Special>Blanks and OK

The blanks in Column C will be selected.

Now, go to Edit>Delete>ENTIRE ROW.


Gord

 

[Batman]

Argh! It's only selecting ONE blank at a time...

 

[Steve]

Select to column where your blanks exist, then run this:

Sub DeleteWhereBlank()
'
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
End Sub

 

[Gord Dibben]

Bat

Is it possible the blank rows are not truly blank?

Try this.

In a empty cell enter =ISBLANK(cellref) where cellref is one of the "blank"
cells.

Does it return TRUE or FALSE?


Gord