With calculation set to Manual, occasionally I would like a workbook that
takes a while to recalculate the whole workbook, just to recalculate the
range I am currently working on. My workround at the moment is to highlight
the range and then cycle through each cell in the range by pressing edit
formula, F2 and then Enter. This is time consuming and noisy when trying to
cycle through the range quickly. This 'problem' is not specific to one
workbook as I have one workbook for each month of the year.
Is there a quicker method?