Program timing

  • Thread starter Thread starter Christof DB
  • Start date Start date
C

Christof DB

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
 
Take a look at Timer in XL Help.

For other speedups, it's hard to tell without seeing your code.
 
Back
Top