|
本帖最后由 dpdmlym 于 2013-1-18 11:00 编辑
- Sub 找重复值()
- Dim d, arr, str As String, brr, m As Integer
- m = 3
- arr = Sheet1.UsedRange
- Set d = CreateObject("Scripting.Dictionary")
- For i = 1 To UBound(arr, 1)
- For j = 1 To UBound(arr, 2)
- If d.Exists(arr(i, j)) Then
- str = d(arr(i, j))
- brr = Split(str, "/")
- If Cells(Val(brr(0)), Val(brr(1))).Font.ColorIndex = xlAutomatic Then
- Cells(Val(brr(0)), Val(brr(1))).Font.ColorIndex = m
- Cells(i, j).Font.ColorIndex = m
- m = m + 1 '估计没有50个重复的
- Else
- Cells(i, j).Font.ColorIndex = Cells(Val(brr(0)), Val(brr(1))).Font.ColorIndex
- End If
- Else
- d(arr(i, j)) = i & "/" & j
- End If
- Next j
- Next i
- Set d = Nothing
- End Sub
复制代码 |
|