Thank you for your assistance. I assume that checking the 'Iteration' check
box will have no noticeable effect on the operation of the workbook.

Jerry

--
Saskatoon Jerry


"JE McGimpsey" wrote:

One way:

Choose Tools/Options/Calculation and check the Iteration checkbox.

to monitor cell A1 in cell B1, enter this in B1:

=IF(A1B1, A1, B1)



In article ,
Saskatoon Jerry wrote:

Looking for a function or macro that captures and retains the maximum value
of a fluctuating real number in a cell