| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I write a function that automatically changes over time | Excel Worksheet Functions | |||
| Coomplete the formula | Excel Worksheet Functions | |||
| How do I write a formula in excel that will calculate time? | Excel Programming | |||
| How do I write an Excel formula to calculate my working time? | Excel Worksheet Functions | |||
| How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
Linear Mode
