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

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
 
D

Don Guillett

One way, sorted or not
Sub DeleteBlanks()
Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with an excel macro to group & outine rows 0
Delete rows in a sequence 9
Macro: How to create a new excefile - named as given in a cell-value 4
macro to select a range from a set cell to a specified cell 6
Macro in Excel deleting specified rows 2
Delete rows with macro code 3
Macro: make list of all files in all folder with sub folders 5
How to start a macro with pivot-chart-update-button (!) 4

Top