|
- Sub tsst()
- Dim arr, a, j As Byte, k As Byte
- Dim arrCon
- Dim arrA(1 To 65536, 1 To 1), lPos As Integer
- arr = ActiveSheet.UsedRange.Columns(2).Value
- arrCon = Range(Range("c3"), Range("c3").End(xlToRight)).Value
- For i = LBound(arrCon, 2) To UBound(arrCon, 2)
- arrCon(1, i) = Trim(arrCon(1, i))
- Next
- For Each a In arr
- If Len(a) Then
- For Each b In arrCon
- k = 0
- For j = 1 To Len(a)
- If InStr(b, Mid(a, j, 1)) Then k = k + 1
- If j = 2 And k = 0 Then Exit For
- Next
- If k > 1 Then
- lPos = lPos + 1
- arrA(lPos, 1) = "'" & a
- End If
- Next
- End If
- Next
- If lPos Then
- With Columns(1)
- .Clear
- .Cells(1, 1).Resize(lPos).Value = arrA
- End With
- MsgBox "完成"
- End If
- End Sub
复制代码 这样有重复的在A列。
|
|