View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MJKelly MJKelly is offline
external usenet poster
 
Posts: 114
Default testing efficieny/speed of a macro

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