calculation in a worksheet
NON-code option:
Set WB to manual.
To calculate *only* the active sheet:
<Shift <F9
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Zone" wrote in message
...
You can do it the other way around. Set the calculation to manual, then
calculate range(s) in the sheet like this:
Sub Test()
Range("c1:c85").Calculate
End Sub
HTH, James
"yshridhar" wrote in message
...
Hello everybody
Is there any way to disable calculation of a particular sheet in a
workbook? I would like the calculation option for the workbook to be
automatic.
With regars
Sridhar
|