Sub kosoku_Rei() Dim I as Long With Application '高速化はじめ .ScreenUpdating = False '描画停止 .EnableEvents = False 'イベント監視停止 .Calculation = xlCalculationManual '手動計算 End With '------------実行処理を行うコードを書く(高速化のコードで囲む)--------- Dim I = 1 to 100000 Cells("A",I) = I Next I '--------------------------------------------------------------- With Application '高速化おわり .ScreenUpdating = True '描画再開 .EnableEvents = True 'イベント監視再開 .Calculation = xlCalculationAutomatic '自動計算 End With End Sub
Sub hikakuTEST() Dim I As Long Dim TIME_S, TIME_E, TIME_G As Date TIME_S = Now() '処理の実行前に時間を代入 For I = 1 To 1000000 Cells(I, "A") = I Next I TIME_E = Now() '処理の終了後に時間を代入 TIME_G = TIME_E - TIME_S '終了後-実行前=差の時間を算出 MsgBox TIME_G '差の時間を表示する(処理時間) End Sub
Sub hikakuTEST2() Dim I As Long Dim TIME_S, TIME_E, TIME_G As Date With Application '高速化はじめ .ScreenUpdating = False '描画停止 .EnableEvents = False 'イベント監視停止 .Calculation = xlCalculationManual '手動計算 End With TIME_S = Now() '処理の実行前に時間を代入 For I = 1 To 1000000 Cells(I, "A") = I Next I TIME_E = Now() '処理の終了後に時間を代入 TIME_G = TIME_E - TIME_S '終了後-実行前=差の時間を算出 With Application '高速化おわり .ScreenUpdating = True '描画再開 .EnableEvents = True 'イベント監視再開 .Calculation = xlCalculationAutomatic '自動計算 End With MsgBox TIME_G '差の時間を表示する(処理時間) End Sub