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 ***

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)

"jay dean" wrote in message
...
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 ***