My guess is that it has too many limitations, being restricted to
column A and without regard to rest of cells on the row. But the
question is too ambiguous anyway.

Some more examples of deleting cells and rows in
Delete Cells/Rows in Range, based on empty cells, or cells with specific values
http://www.mvps.org/dmcritchie/excel/delempty.htm

Can't read the example but I think the interest is probably in deleting rows
which would bring you down to the second half of the above.

As for the subject title you might look at some VBA tutorials on my page
http://www.mvps.org/dmcritchie/excel....htm#tutorials
and also you would want to write code that runs quickly as opposed to just working
http://www.mvps.org/dmcritchie/excel/proper.htm
http://www.mvps.org/dmcritchie/excel/slowresp.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mike Q." wrote...
Does this help?

Sub NoBlanksAligLeft()
Columns("A:A").SpecialCells(xlCellTypeBlanks).Sele ct
Selection.Delete Shift:=xlUp
Columns("A:A").HorizontalAlignment = xlLeft
End Sub
--
Mike Q.


"excel macro" wrote:
How do i delete blank cells and align properly through macro?