- Sub yy()
- Application.ScreenUpdating = False
- Dim Arr, d, k, t, x$
- Dim i%, j%, aa
- Set d = CreateObject("Scripting.dictionary")
- Arr = Range("c5:f15")
- For i = 1 To UBound(Arr)
- If Arr(i, 1) <> "" And Arr(i, 4) <> "" Then
- x = Arr(i, 1) & "|" & Arr(i, 4)
- d(x) = d(x) & i & ","
- End If
- Next
- k = d.keys
- t = d.items
- For i = 0 To UBound(k)
- t(i) = Left(t(i), Len(t(i)) - 1)
- If InStr(t(i), ",") Then
- aa = Split(t(i), ",")
- For j = 0 To UBound(aa)
- Cells(aa(j) + 4, 3).Interior.ColorIndex = 6
- Cells(aa(j) + 4, 6).Interior.ColorIndex = 6
- Next
- End If
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |