第1个回答 2016-01-29
Sub s()
ceto = 2
t = Cells(Rows.Count, ceto).End(3)
n = Cells(Rows.Count, 11).End(3).Row
For i = 11 To 353
If Cells(n, i) > 2 Then
If Cells(n, i) - 3 = Cells(n - 1, i) Then Cells(1, i) = t
ElseIf Cells(n, i) = 0 Then
If Cells(n - 1, i) = 9 Then Cells(1, i) = t
Else
If Cells(n, i) + 6 = Cells(n - 1, i) Then Cells(1, i) = t
End If
Next
End Sub本回答被提问者采纳