VBA to delete row in another worksheet based on cell being blank

[gpart1977]

I'm looking for a VBA code to delete an entire row in worksheet "A" based on the value of a cell in worksheet "B" being blank. So, for example, if cell J23 in worksheet "B" is blank then delete row 9 from worksheet "A". Is anyone able to provide VBA code to do this? I'm sure this is probably quite easy but I am new to VBA coding.

Thanks

 

[mumps]

Try:

Sub DelRow()
    If Sheets("B").Range("J23") = "" Then
        Sheets("A").Rows(9).EntireRow.Delete
    End If
End Sub

 

[gpart1977]

Awesome, thank you so much!

 

[mumps]

You are very welcome.