Deleting Rows

Have you tried autofilter ?

Highlight your entire range including column headings and select :

data
filter
autofilter

then on the column where you have your blanks, click on the downarrow

from the dropdown list, select "blanks"

this will filter out anything that isn't blank in that column

then highlight all those rows and right click and select :

delete rows

then remove your filtering and it should have deleted your rows which contained blanks in that column

HTH
Chris

I was going to recommend a manual way rather than a macro for this problem

Oooops

I didn't see the word "code" in the question, I do apologise Qroozn.

Go for it - my VBA is totally woeful, hence me hanging on to manual solutions !

:-)

On Error Resume Next
Intersect(Selection, Columns("A:A")).SpecialCells(xlCellTypeBlanks).EntireRow.Delete

I didn't give coed beacuse the manual way is much easier i think.. i believe stay away from script unless it is necessary.

Or ....

..... like this :-

Select Column A
Go to Edit>GoTo>Special>Blanks>OK
Go to Edit>Delete...>EntireRow