VBA - Measuring Time -subsecond

[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

 

[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)

 

[PShield]

Many thanks Bob -its just what I need

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

Thanks again