testing efficieny/speed of a macro

[MJKelly]

Hi,

I have a few macros which perform the same tasks. How can I measure
their speed of execution (start to finish), so I can only use the
fastest and delete the others. Also, would this be a good method of
identifying how efficient a macro is i.e using different looping
methods or the difference of copying data using filters or the offset
command?

I was thinking of some sort of timer to log the time taken for the
macro to run and complete?

any idea's?

Matt

 

[Bob Phillips]

One simple way

Dim nTime As Double

nTime = Timer

'your code

Msgbox Timer - nTime 'time i secs

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[MJKelly]

Thanks Bob,

Works a treat!.

Matt