Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide macros executions | Excel Programming | |||
Hide macros executions | Excel Programming | |||
Hide macros executions | Excel Programming |