Another way to use a timer feature with less code is:

StartTime = Now
'...
'Lots of code
'...
StopTime = Now
TElapsed = Format(StopTime - StartTime, "hh:mm:ss")

Which is what I use when I need to see how long a macro is running. Pop it
into a msgbox. I can leave my desk and still get the run time.