Create a toolbar button and add this code

Private Sub RangeCalculate()
Selection.Calculate
End Sub

selec t the cells, and click the button.

--
HTH

Bob Phillips

"Knokie From Holland" <Knokie From wrote
in message ...
How can I calculate a selection in a large worksheet. One of my
worksheets
collects only the results of several other worksheets. This worksheet is
190MB and needs for a full calculation over 70 minites. Memory and
processor
have enough capacity and I am running Windows XP Pro with Office 2003.

I wish to make a selction and calculate only this selection. Who has a
solution?