ExcelBanter - Time the Execution Speed of Procedure in Milliseconds

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Time the Execution Speed of Procedure in Milliseconds (https://www.excelbanter.com/excel-programming/416038-time-execution-speed-procedure-milliseconds.html)

RyanH

Time the Execution Speed of Procedure in Milliseconds

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

--
Cheers,
Ryan

Barb Reinhardt

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

All times are GMT +1. The time now is 03:38 AM.