VBA - Measuring Time -subsecond

P

PShield

I need to accuratly measure the time for a part of a procedure in a VBA
subroutine.

It looks like Now() and time only measure to the nearest second, and I
need much finer granularity.

I cannot just run the proc for a number of iterations and devide by
that number of iterations

Can anyone help :)
 
B

Bob Phillips

Look at Timer in VBA Help, it might be just what you need.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
P

PShield

Many thanks Bob -its just what I need

I'm really not sure how I missed it in "Help"

Thanks again
 
Top