Sub TEST()
For I = Range("B65536").End(3).Row To 2 Step -1
If InStr("张三|李四", Cells(I, "B").Value) Then
GoTo 10
Else
Rows(I).Delete
End If
10 Next
End Sub
Sub TEST()
For I = Range("B65536").End(3).Row To 2 Step -1
If InStr("张三|李四", Cells(I, "B").Value) Then
GoTo 10
Else
Rows(I).Delete
End If
10 Next
End Sub
Sub test()
Dim i As Integer
Dim arr
arr = Range("a1", Range("b65536").End(xlUp))
For i = UBound(arr) To 2 Step -1
x = UBound(arr)
p = arr(i, 2)
m = 0
If arr(i, 2) = "àîËÄ" Or arr(i, 2) = "ÕÅèy" Then
m = 1
End If
If m <> 1 Then
Range("a" & i).EntireRow.Delete
End If