Macro to delete all (and only) rows with cell value "" (blank) incolumn A

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hey Guys
Still strugling here :(
I want my macro to delet all rows as described in the subject.
Will anyone give me a hand on this?
In advance of the maco sequence I have sorted datatable and all theese
rows are place in the bottom of the table.


best regards
Snoopy
 
One way, sorted or not
Sub DeleteBlanks()
Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
 
Back
Top