|
发表于 2012-1-15 21:55
|
显示全部楼层
本楼为最佳答案
本帖最后由 sunjing-zxl 于 2012-1-16 08:05 编辑
- Sub bb()
- Dim d As New Dictionary
- Dim arr, i As Long, j As Long
- Dim Ro As Long, Co As Long
- Application.ScreenUpdating = False
- arr = Range(Cells(2, "F"), Cells([F65536].End(xlUp).Row, [F2].End(xlToRight).column))
- For i = 1 To UBound(arr) Step 3
- For j = 1 To UBound(arr, 2)
- If Not d.Exists(arr(i, j) & vbTab & arr(i + 1, j)) Then
- d.Add arr(i, j) & vbTab & arr(i + 1, j), Array(i, j)
- Else
- Ro = d(arr(i, j) & vbTab & arr(i + 1, j))(0)
- Co = d(arr(i, j) & vbTab & arr(i + 1, j))(1)
- Range(Cells(Ro + 1, Co + 5), Cells(Ro + 2, Co + 5)).Font.Color = -16776961
- Range(Cells(i + 1, j + 5), Cells(i + 2, j + 5)).Font.Color = -16776961
- End If
- Next j
- Next i
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|