Hi All,

How do you display the runtime of a macro?

E.g 

Sub Macro()
[Standard macro code]
[What lines of code to enter here to display runtime of macro?]
End Sub
By the Bold line, the output should be "Macro took 2:56 hrs to run" in say cell A1 in Sheet1.

Any ideas?

Regards.