|
本帖最后由 一掷乾坤 于 2023-4-21 06:40 编辑
Sub ceshi()
d = 3
c = 1048576
a = Cells(3, "o").Value
For i = d To c
If Cells(i, "o").Value * Cells(i + 1, "o").Value > 0 Then
b = Cells(i + 1, "o").Value
If b < 0 Then
If a > b Then
a = b
ElseIf b - a > 10 Then
Cells(i + 1, "n").Value = b
End If
ElseIf b > 0 Then
If b > a Then
a = b
ElseIf a - b > 10 Then
Cells(i + 1, "n").Value = b
End If
End If
ElseIf Cells(i, "o").Value * Cells(i + 1, "o").Value < 0 Then
a = Cells(i + 1, "o").Value
ElseIf Cells(i + 1, "o").Value = "" Then
Exit For
End If
Next i
End Sub |
|