Help with Macro Code

[markster]

Hello
I need help with a bit of Macro code. I have managed to figure out most of it by recording and trial and error. The only thing I can't figure out is a line of code that should look down A and any blank cells in column A it deletes the entire row. E.g. A7 might be blank so it deletes the entire row, A9 maybe blank so it deletes the entire row. A11 might be blank so it deletes the entire row. Any blank cells may be shaded but that doesn't matter - if there is not a value in an A cell then it should delete the entire row regardless of whether it is shaded or not.

Thanks
Mark

 

[JB2020]

How about

Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeBlanks).EntireRow.Delete

If you have blank cells at the bottom which that doesn't pick up, you might want to use

ActiveSheet.UsedRange.Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Delete

instead

 

[markster]

Thank you so much. Have a great day.