Sub 最大连续次数Do()
i = 8
Do While i <= 22
If Cells(i, 2) = [c24] Then
k = k + 1
If k > temp Then temp = k
Else
k = 0
End If
i = i + 1
Loop
Cells(24, "e") = temp
End Sub
Sub 最大连续次数Do()
i = 8
Do While i <= 22
If Cells(i, 2) = [c24] Then
k = k + 1
If k > temp Then temp = k
Else
k = 0
End If
i = i + 1
Loop
Cells(24, "e") = temp
End Sub