"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
--