|
一目了然的事,还要宏去完成?
加一句判断过滤掉吧!
Sub TEST()
ARR = Range("V1:V" & Range("V65536").End(3).Row)
BRR = Range("Y2:Y" & Range("Y65536").End(3).Row)
If Not IsArray(ARR) Or Not IsArray(BRR) Then Exit Sub
For I = 1 To UBound(ARR)
For J = 1 To UBound(BRR)
If Left(BRR(J, 1), 1) = Right(BRR(J, 1), 1) Then GoTo 10
S = 0
W = ARR(I, 1)
For T = 1 To Len(BRR(J, 1))
Q = InStr(W, Mid(BRR(J, 1), T, 1))
If Q Then
S = S + 1
W = Left(W, Q - 1) & Right(W, Len(W) - Q)
End If
Next
If S = Len(BRR(J, 1)) Then ARR(I, 1) = "": Exit For
10 Next
Next
Range("Z:Z").ClearContents
For I = 1 To UBound(ARR)
If ARR(I, 1) <> "" Then Range("Z65536").End(3)(2) = ARR(I, 1)
Next
Range("Z1").Delete
End Sub
|
|