M
Michael R
My piece of code runs under manual calculation mode. When it is done I want
the whole lot to be recalculated.
Towards the end of my code I have the following statements:
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
End Sub
The problem:
Watching the worksheet status in the right bottom corner of the screen I see
that the lot is calculated twice (the "Calculating xx%" runs from 0 to 100
twice) which is a bit of a nuisance since it takes quite a while.
How can I get it to calculate only once?
the whole lot to be recalculated.
Towards the end of my code I have the following statements:
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
End Sub
The problem:
Watching the worksheet status in the right bottom corner of the screen I see
that the lot is calculated twice (the "Calculating xx%" runs from 0 to 100
twice) which is a bit of a nuisance since it takes quite a while.
How can I get it to calculate only once?