|
- Sub tt()
- arr = Range("c1:c" & [c65536].End(3).Row)
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr)
- xrr = Split(arr(i, 1), " ")
- p = 0
- For k = 0 To UBound(xrr)
- x = xrr(k)
- If Len(x) > 0 Then
- If Not d.exists(x) Then
- d(x) = ""
- Else
- p = 1
- xrr(k) = "重 复"
- End If
- End If
- Next
- If p = 1 Then h = h & "," & i: arr(i, 1) = Join(xrr, " ")
- Next
- [f1].Resize(UBound(arr)) = arr
- If Len(h) Then MsgBox "第" & Mid(h, 2) & "行出现重复"
- End Sub
复制代码 |
|