View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Morris[_2_] Morris[_2_] is offline
external usenet poster
 
Posts: 25
Default Evaluate time spent on macro running

I was thinking of retrieving the time at the beginning of the macro, eg
in 10:31:02 converted to seconds (=37802 or sth) and then the time of
"seconds" at the end. Then subtract it and voila - convert it to
minutes and seconds (the macro runs for about 2-5 mins.

Is there any quick way to do that? Or is there a smarter way?

Cheers