R
RyanH
I would like to time the speed of a macro. I currently use this code, but
the StartTime and EndTime are the same, is that right? I don't think the
Time function is precise enough. Is there a accurate way of timing the speed
of a macro?
Sub TimeMacro()
Dim StartTime As Single
Dim EndTime As Single
StartTime = Time
Debug.Print "Start Time = " & StartTime
' my code here
EndTime = Time
Debug.Print "End Time = " & EndTime
Debug.Print "Elapsed Time = " & EndTime - StartTime
End Sub
the StartTime and EndTime are the same, is that right? I don't think the
Time function is precise enough. Is there a accurate way of timing the speed
of a macro?
Sub TimeMacro()
Dim StartTime As Single
Dim EndTime As Single
StartTime = Time
Debug.Print "Start Time = " & StartTime
' my code here
EndTime = Time
Debug.Print "End Time = " & EndTime
Debug.Print "Elapsed Time = " & EndTime - StartTime
End Sub