|
- Sub tt()
- arr = [a1].CurrentRegion
- [a1].CurrentRegion.Font.ColorIndex = 0
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr)
- a = arr(i, 1): b = arr(i, 2)
- For k = 1 To Len(a)
- c = Mid(a, k, 1)
- d(c) = 1
- Next
- For k = 1 To Len(b)
- c = Mid(b, k, 1)
- If d(c) = 1 Then
- s = s + 1
- d(c) = 0
- End If
- Next
- If s >= 2 Then Cells(i, 1).Resize(1, 2).Font.Color = vbRed
- s = 0: d.RemoveAll
- Next
- End Sub
复制代码 |
|