executions per second
 

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

executions per second
 

=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 toolsoptions menu).

"N+" wrote:

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

executions per second
 

ty ryan !! now may I insert a "calculate now" command in my self running
macro ??
ty




"ryan" wrote:

=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 toolsoptions menu).

"N+" wrote:

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