Why not login to Qiita and try out its useful features?

We'll deliver articles that match you.

You can read useful information later.

0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

自分が欲しかった、コードの処理時間を調べるVBAのテンプレート

Posted at
テンプレート
Sub 印刷用()
’目的のコードが正常に動作することを確認したらすぐ下の行を非コメントブロック
'Application.ScreenUpdating = False

Dim a, b As Double
Application.DisplayAlerts = False
    a = Timer

'目的のコードを開始

'目的のコードを終了
    b = Timer
    
    Debug.Print b - a
    
End Sub

0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?