View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nevyenn
 
Posts: n/a
Default Want to measure macro elapsed time.

I would like to add an elapsed time function to some of my macros to
determine some performance benchmarks for different PCs. One of my macros is
performing a lookup of roughly 10,000 items against a separate sheet
containing 48 columns of data. (I need to do this because our inventory
control system and MRP systems are not being very friendly.) The way that I
am currently accomplishing this takes a significant amount of time, and I'd
like to be able to record the exact time the macro runs.