TIMING EXECUTION DURATION!

[jay dean]

This macro when added to my code should write the time duration it takes
for my code to execute (from start to finish) in minutes or seconds in
Range("A1") as a string like "Total Execution Time: X seconds".

Any help would appreciated!

Thanks
Jay



*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

Dim nTime As Double

nTime = Timer
... your code
Next

Range("a1")Value ="Total execution time: " & Timer - nTime & " seconds"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)