Sub tt()
Dim ar, r
ar = [a1].CurrentRegion
For r = 1 To UBound(ar)
If ar(r, 2) Like "*hj*" Then
ar(r, 2) = ""
End If
Next
[a1].CurrentRegion = ar
End Sub
Sub tt()
Dim ar, r
ar = [a1].CurrentRegion
For r = 1 To UBound(ar)
If ar(r, 2) Like "*hj*" Then
ar(r, 2) = ""
End If
Next
[a1].CurrentRegion = ar
End Sub