- Sub test()
- Dim r%, i%
- Dim arr, brr, zrr()
- With Worksheets(1)
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("j1:k" & r)
- xm = ""
- For i = 2 To UBound(arr)
- If arr(i, 1) & "+" & arr(i, 2) <> xm Then
- m = m + 1
- ReDim Preserve zrr(1 To 2, 1 To m)
- zrr(1, m) = i
- zrr(2, m) = i
- xm = arr(i, 1) & "+" & arr(i, 2)
- Else
- zrr(2, m) = i
- End If
- Next
- .Rows("2:" & r).Interior.ColorIndex = xlNone
- For k = 1 To UBound(zrr, 2)
- .Rows(zrr(1, k) & ":" & zrr(2, k)).Interior.ColorIndex = IIf(k Mod 2 = 1, 8, 15)
- Next
- End With
- End Sub
复制代码 |