executions per second

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
 
R

ryan

=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).
 
N

N+

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top