Deleting blank rows using loop and SpecialCells

Hi all,

Trying to work through a column and delete rows where any cell in Col G is empty.

Using this

Please Login or Register  to view this content.

will find the first blank cell and delete that row but because it's working its way down the sheet instead of up it then misses the next blank row and therefore is not working as I would like it to.

Can anyone help me in perhaps working through the sheet backwards while still using SpecialCells(xlCellTypeBlanks) as I think this would be fasgter than looping through each and every cell in Col G.

Many thanks

Seamus

If you select Column G and then run the below it will delete the entire row that has an empty cell.

Please Login or Register  to view this content.

I find that this one line of code works great because it can be used on different columns and is not specialized to a column or certain number of rows.

Thanks to both of you - I should have known that!

Regards

Seamus