Procedure

Informatic · Oct 28, 2002

Hello...

How can I see how long a procedure is being run.

Can somebody Help me....

mp9 · Oct 28, 2002

Put these lines at the start of your function

Code:

Dim datTimestamp As Date
datTimestamp = Now()

and these at the end

Code:

Debug.Print ((Now() - datTimeStamp) * 24 * 60 * 60) & &quot; seconds&quot;

Then watch your debug window as the procedure runs to see how long it is taking. Is this what you're after? [pc2]