Maybe:
Sub Quint6778z()
Dim i As Long, x As Range, y, z As String, ws As Worksheet
With Application
.Calculation = xlCalculationManual
.ScreenUpdating = False
End With
Set ws = ActiveSheet
With ws
ReDim y(2 To .Range("A" & Rows.Count).End(3).row)
For i = UBound(y) To LBound(y) Step -1
z = .Cells(i, "B")
Set x = Sheets("DATACRITERIA").Columns(1).Find(.Cells(i, "A"), LookIn:=xlValues, lookat:=xlWhole)
If Not x Is Nothing Then
If x.Offset(, 1) = z Then .Rows(i).Delete
End If
Set x = Nothing
Next i
End With
With Application
.Calculation = xlCalculationAutomatic
.ScreenUpdating = True
End With
End Sub
Bookmarks