View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Time the Execution Speed of Procedure in Milliseconds

I use this

Dim BegTime
BegTime = Timer

(at the beginning)

and
MsgBox("Elapsed time: " & timer - BegTime)

I don't recall the units though. (I'd hav
--
HTH,
Barb Reinhardt



"RyanH" wrote:

How can I time execution speed of a procedure in milliseconds?

--
Cheers,
Ryan