filter and empty cells

[lezawang]

Hi
I have a table like the one below. I want to apply filter so I can find empty cells and then delete them. When I apply filter on Name column, the filter give me only 2 names, Mary1 and Jack1. I do not see David1 in the list. I think because of the empty Row (row #3 , I put dot so you can see it but it is empty). How can I fix that? Thank you.

[TABLE="width: 200"]
<tbody>[TR]
[TD]name
[/TD]
[TD]jan
[/TD]
[TD]feb
[/TD]
[TD]mar
[/TD]
[/TR]
[TR]
[TD]mary1
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]33
[/TD]
[/TR]
[TR]
[TD]jack1
[/TD]
[TD]10
[/TD]
[TD]33
[/TD]
[TD]55
[/TD]
[/TR]
[TR]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[/TR]
[TR]
[TD]david1
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]89
[/TD]
[/TR]
</tbody>[/TABLE]

 

[mumps]

If you want to delete all blank rows, this macro will do that.

Sub DeleteRows()
    Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub