How Can I write a function that calculate the time it take to coomplete all the loops
 

I have many loops in my vba programme.
How Can I write a function that calculate the time it take to coomplete
all the loops?
thanks

How Can I write a function that calculate the time it take to coomplete all the loops
 

Set a timer at the start of the loop, and the end

nTime = Timer
'loop code
MsgBox Timer - nTime

but you need to run several times and average (and ignore best and worst?)
as other activity will affect the timings

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
oups.com...
I have many loops in my vba programme.
How Can I write a function that calculate the time it take to coomplete
all the loops?
thanks