And of course, there is also:
Shift F9
Which *only* calculates the active (in focus) sheet.
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"Max" wrote in message
...
"redchequer" wrote:
.. I am curious to find out how
Pressing F9 will recalculate the numbers.
Harlan's formula uses RAND() which returns a new random number every time
the worksheet is calculated. Pressing F9 is a short-cut keystroke which
will (from Excel's help) calculate all worksheets in all open workbooks.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--