Sub aa()
With Sheets("1")
For i = 2 To .Range("a65536").End(xlUp).Row
Set Rng = Sheets("2").[a:a].Find(.Cells(i, 1), lookat:=xlWhole)
If Not Rng Is Nothing Then
Rng.EntireRow.Delete
End If
Next
End With
End Sub
Sub test()
Dim str$
Sheets("1").Select
For i = 1 To Range("a65536").End(xlUp).Row
str = Cells(i, 1)
If Len(str) > 0 And Len(str) < 256 Then
Set Rng = Sheets("2").[a:a].Find(str, lookat:=xlWhole)
If Not Rng Is Nothing Then
Rng.EntireRow.Delete
End If
End If
Next
End Sub
Sub test()
Dim str$
Sheets("1").Select
For i = 1 To Range("a65536").End(xlUp).Row
str = Cells(i, 1)
If Len(str) > 0 And Len(str) < 256 Then
Set Rng = Sheets("2").[a:a].Find(str, lookat:=xlWhole)
If Not Rng Is Nothing Then
Rng.EntireRow.Delete
End If
End If
Next
End Sub