- Sub aa()
- Dim i%, j%, str$, arr, d As Object
- Set d = CreateObject("scripting.dictionary")
- With Sheets("Sheet2")
- arr = .Range("A1:I" & .Range("A" & Rows.Count).End(3).Row)
- For i = 1 To UBound(arr)
- If Not d.Exists(arr(i, 1) & "," & arr(i, 3) & "," & arr(i, 4) & "," & arr(i, 6) & "," & arr(i, 7) & "," & arr(i, 9)) Then
- d(arr(i, 1) & "," & arr(i, 3) & "," & arr(i, 4) & "," & arr(i, 6) & "," & arr(i, 7) & "," & arr(i, 9)) = i
- Else
- j = d(arr(i, 1) & "," & arr(i, 3) & "," & arr(i, 4) & "," & arr(i, 6) & "," & arr(i, 7) & "," & arr(i, 9))
- If InStr(str, "C" & j & ":I" & j & ",") = 0 Then str = str & "C" & j & ":I" & j & ","
- End If
- If Len(str) > 250 Then
- .Range(Left(str, Len(str) - 1)).Interior.ColorIndex = 6
- str = ""
- End If
- Next
- If str <> "" Then .Range(Left(str, Len(str) - 1)).Interior.ColorIndex = 6
- End With
- End Sub
复制代码 |