| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timing VBA code
I have a VBA routine that may take a considerable amount of time to execute
(~20minutes). I would like to have the code time itself and record the value in a workbook to allow other future users to know how long the routine is likely to take. Has anyone done this? Any ideas on how to proceed? Thanks, Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Timing VBA code
v1=Time
do lots of stuff v2=Time Msgbox(v2-v1) -- Gary's Student "Steve M" wrote: I have a VBA routine that may take a considerable amount of time to execute (~20minutes). I would like to have the code time itself and record the value in a workbook to allow other future users to know how long the routine is likely to take. Has anyone done this? Any ideas on how to proceed? Thanks, Steve |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Timing VBA code
Var1 = Now()
'Your Code Range("A1") = Now() - Var1 Charles Steve M wrote: I have a VBA routine that may take a considerable amount of time to execute (~20minutes). I would like to have the code time itself and record the value in a workbook to allow other future users to know how long the routine is likely to take. Has anyone done this? Any ideas on how to proceed? Thanks, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Timing/loading bar | Excel Programming | |||
| Timing a macro | Excel Discussion (Misc queries) | |||
| Timing loop help please | Excel Programming | |||
| VB Timing Question | Excel Programming | |||
| Timing Problem can someone help please | Excel Programming | |||
Linear Mode
