Macro to Delete if cell empty

[Daywalker]

Hi,

I've been searching all morning for a macro that will look at a sheet of data, and then look at a specific column, then if the cell is empty, delete the full row.

Came across the below which I tried to modify (as below), but its not really working. I also have the cells set up with a "Conditional Format", which I'm usure if that is stopping it deleting also.

Anyone help ?

-----------------------------------------------------------------------

Please Login or Register  to view this content.

-------------------------------------------------------------------------

[mrice]

What do you actually mean by 'not really working?'

[Daywalker]

Hi Martin,

What its actually doing, is deleteing the header row, but the rest of the cells that have no data in them (column H), it's not deleting them. Thats why I started to think it might be cause I have the cells set up with a "Conditional Format" ?.

[mudraker]

The problem is being caused by you looking for the last row used row i column H. If column H is vacant apart for the header in row 1 then your macro will only loop for row 1

You will need to change the column letter for this line of code

Please Login or Register  to view this content.

or use this

Please Login or Register  to view this content.