|
两段非常简单代码,想测试下段代码的时间更长,好像与某些书的理论不一致.
Sub 一()
Dim tim As Long
tim = Timer
For i = 1 To 1000
Range("A1").Font.Name = "黑体"
Range("A1").Font.FontStyle = "加粗 倾斜"
Range("A1").Font.Size = 11
Range("A1").Font.Underline = xlUnderlineStyleNone
Range("A1").Font.Color = 192
Next i
MsgBox "程序共运行了" & Format(Timer - tim, "0.00") & "秒"
End Sub
Sub 二()
Dim tim As Long
tim = Timer
For i = 1 To 1000
With Range("A1").Font
.Name = "黑体"
.FontStyle = "加粗 倾斜"
.Size = 11
.Underline = xlUnderlineStyleNone
.Color = 192
End With
Next i
MsgBox "程序共运行了" & Format(Timer - tim, "0.00") & "秒"
End Sub |
|