Solved: Timer for code execution

[cavemonkey]

Hi

I'm just wondering if anyone knows of any code that can record the amt of time needed to execute a code?

I need to show my superviosr that the new code I wrote is faster than the older one.

Thanks

[acw]

Hi

At the start of your code put in a variable to record the starting time. At the end, you can then subtract that time from the current time and show the elapsed time


starttime = now()
.......
msgbox format(now()-starttime,"hh:mm:ss")


If you like, you could put the result to a cell on the sheet, and format the cell to be in time mode.

HTH

Tony

[cavemonkey]

Ic thanks a lot.