Hello Rabbitstew,

This will delete row 10 on the ActiveSheet if A2 contains no data.
    If Range("A2") ="" Then Rows(10).EntireRow.Delete