Getting Error 438 when Running macro from Sht1 to delete row on Sht2

[Sleeplol]

Hello Everyone,

Getting a runtime 438 when running this.

I believe everything is defined...

How would you write this properly if the macro is ran from Sheet "SignoffChecks"???

Thanks for any help

Sub SignOffDeleteRow()

Dim r As Long
Dim LastRow As Long
LastRow = Worksheets("Sign_Off_Selection").Cells(Rows.Count, "A").End(xlUp).Row
For r = Worksheets("Sign_Off_Selection").LastRow To 1 Step -1
If Worksheets("Sign_Off_Selection").Cells(r, 8) = Worksheets("SignoffChecks").Range("H11") Then
Rows(r).Delete
End If
Next r

End Sub

 

[MARK858]

Hi @Sleeplol, just to solve confusion the 858 is part of a targeting range as in "Mark 858" (think films about submarines).

Happy you got a solution (even though I missed the problem further on) ?

 

[Sleeplol]

Ah, roger that Sailor
Way cooler than a SoCal area code lol

 

[MARK858]

Ah, roger that Sailor
Way cooler than a SoCal area code lol

Wasn't a sailor, I was on the R&D side doing testing in my younger days