Excellent/ Always a good feeling :-)

Bob

"Knokie From Holland" wrote in
message ...
Thanks Bob, it is running fast.

Knokie

"Bob Phillips" wrote:

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?