executions per second

  • Thread starter Thread starter N+
  • Start date Start date
N

N+

hi all i have a page that runs my useful macro timer by bob !
but it uses very much cpu because it performs calculations of the page many
times per seconds..i mean that at the round second it reports a value and
stops , but between 1 second of timer and other, an easy RAND() cell, changes
a lot of times..
can i fix that ?? ty
 
=rand() will always recalc everytime you change something in your worksheet.
you could either freeze your random numbers by copying them and pasting them
down as values, or you could turn off automatic calculation (either as part
of your code, or just through the tools>options menu).
 
Back
Top