Thread: Program timing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christof DB Christof DB is offline
external usenet poster
 
Posts: 14
Default Program timing

Hi,

A common problem: I've steadily added code up till the
moment it takes about 2 seconds to run a particular sub.
In order to improve that, I'd like to do some timing of
routines, however, the only possible timing I found is
per second, which does not help me.
Q1:
Is there a way to get a time indication in smaller units
that seconds?
(don't tell me I should run the macro repeatively because
this is not a valid option in this particular case)

Q2: is there anything else I can do to speed up the code
(screenupdate & calculation are off already)

Thanks a lot
Christof