Selecting Blank Cells
 

What is a formula I can plug into a macro to select all blank rows in column
A, then deleting the entire row? Thanks!!!

Selecting Blank Cells
 

Try:

On Error Resume Next
Columns("A").SpecialCells(xlBlanks).EntireRow.Dele te
On Error GoTo 0

---
Regards,
Norman


"bodhisatvaofboogie" wrote in
message ...
What is a formula I can plug into a macro to select all blank rows in
column
A, then deleting the entire row? Thanks!!!

Selecting Blank Cells
 

columns("A").specialcells(xlblanks).entirerow.dele te

HTH
--
AP

"bodhisatvaofboogie" a écrit
dans le message de news:
...
What is a formula I can plug into a macro to select all blank rows in
column
A, then deleting the entire row? Thanks!!!