Excel macro

  • Thread starter Thread starter lowe_family \(remove this\)
  • Start date Start date
L

lowe_family \(remove this\)

I have a table in Excel that I would lke to search column
A and delete all rows where the cell in column A is empty.
 
The easiest way is to use
Select column A
Edit > Go To > Special > Blanks
than Delete entire rows.
That is providing that the cells are truely empty and don't have a
formula...
You can record this and than use it again.

A trickier way is to do an Advanced filter with the criteria >0
Select column A
Edit > Go To > Special > Visible cells
Copy
Paste on a new sheet

The hard way is to loop through code.
 
Sub DeleteBlanks()
'' Deletes all rows that have blanks in Column A .
Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

HTH
Paul
-------------------------------------------------------------------------------
 
Back
Top