其实也不慢,主要是表格里有公式。只要运行代码前把自动计算关掉就行了。
Sub qcw()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
For i = 3 To 325
If Cells(i, 3) < 1 Or Cells(i, 3) = "" Then
Cells(i, 4) = "×"
Else
Cells(i, 4) = "√"
End If
Next
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub