| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time to complete code/function
interesting, thanks one and all for the replies
"witek" wrote: John wrote: Is there a way for VBA to capture how long it takes for a piece of code or user defined function to run? Like how fast it is on calculating a simple UDF? :) Declare Function GetTickCount Lib "kernel32" () As Long Dim longStart As Long, longStop As Long longStart = GetTickCount ...... longStop = GetTickCount |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I complete increments of time in column A by say 9 min? | Excel Discussion (Misc queries) | |||
| Subtotalling taking long time to complete | Excel Worksheet Functions | |||
| Reading complete Excel using DDE code | Excel Programming | |||
| Complete Newbe - Is this a MACRO function or VB ? | Excel Programming | |||
| Run time - % complete | Excel Programming | |||
Threaded Mode
