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
-------------------------------------------------------------------------------
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Search for empty cells and move cells next to 10
do not delete rows in a list. 1
Need Macro... 8
help with macro 8
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Run macro on all files in a specific folder 3

Back
Top