|
wszbd 发表于 2013-8-24 03:05
老师:
不好意思,这两天出去了,没及时看你的回复。
这个程序有误差,好像把一部分红色的单元格变化了 ...
试试这个代码吧:
若不想单元格颜色显示,就将此名代码作为注释即可。- Cells(i + 3, j + 2).Interior.Color = 255
复制代码- Sub 图052()
- Dim ar, Re
- Dim i As Integer, j As Integer, k As Integer, MaxRow As Integer
- Dim temp As Integer
- Application.ScreenUpdating = False
- MaxRow = [C65536].End(3).Row
- ar = Range("C4:R" & MaxRow)
- ReDim Re(1 To UBound(ar), 1 To 16)
- For i = 2 To UBound(ar) Step 2
- temp = 0
- For j = 1 To 16
- For k = 0 To 9
- If Application.IsNumber(Application.Find(k, ar(i, j))) Then
- If Application.IsNumber(Application.Find(k, ar(i - 1, j))) Then
- Cells(i + 3, j + 2).Interior.Color = 255
- temp = 1
- Exit For
- End If
- End If
- Next k
- Next j
- If temp = 0 Then
- Range("A" & i + 3 & ":R" & i + 3).Interior.Color = 65536
- End If
- Next i
- Application.ScreenUpdating = ture
- End Sub
复制代码 |
|