VBA Macro to delete empty rows

[trid0032]

I'm kind of lost and I'm trying to get a code which will delete a row based on whether an entire row blank in the range of A to I

example if row 9 was blank it would delete row 9 and row 10 would become 9 and so on down.

 

[trid0032]

Perfect, thank you so much!

 

[My Aswer Is This]

Perfect, thank you so much!

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[Michael M]

@trid0032
If you have a lot of data, this will be faster...no loop required

Sub MM1()
Application.ScreenUpdating = False
  With Range("F2", Cells(Rows.Count, "F").End(xlUp))
    .Replace "Load Complete", "#N/A", xlWhole, , False, , False, False
    Columns("F").SpecialCells(xlConstants, xlErrors).EntireRow.Delete
  End With
Application.ScreenUpdating = True
End Sub