Hi Sintek,

Not sure if you looked at the sample file however a couple of reason why your code won't do what is needed in this instance.

The "Blank" cells in column A actually contain spaces (either 10 or 1) so they are not technically blank cells.

The lastrow in Column A is not the last row of data which may need to be deleted, rather this is in Column D.