|
发表于 2014-6-22 21:38
|
显示全部楼层
本楼为最佳答案
- Sub demo()
- Dim i As Long, j As Long
- For i = 1 To Range("c1048576").End(3).Row - 1
- For j = 3 To 12
- If Cells(i, j) = 1 And Cells(i + 1, j) <= 5 And Cells(i + 1, j) >= 1 Then
- Cells(i + 1, 13) = 1
- Exit For
- Else
- Cells(i + 1, 13) = 0
- End If
- Next
- Next
- End Sub
复制代码 楼主试试
|
|