calculation in a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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!
=====================================================

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
 
Back
Top