Stopping Auto calculation in part of worksheet

  • Thread starter Thread starter David_Matano
  • Start date Start date
D

David_Matano

HI need some help

I would like to know how to Turnoff Autocalculation in Part
of the worksheet and let the other parts continue to Autocalculate

HEELP!
 
You could maybe make the formulas you don't want to calculate dependent on
another cell, for example:-
=IF(A1="A",SUM(I1:I6),"")
This would calculate of course, but wouldn't give a result unless A1
contained 'A'
Regards,
Alan.
 
HI need some help

I would like to know how to Turnoff Autocalculation in Part
of the worksheet and let the other parts continue to Autocalculate

HEELP!
Click to expand...

Go Tools|Options|Calculation then select Manual then OK.

Then run a macro like...

Public Sub CalculateRow4()
Range("4:4").Calculate
End Sub

In this example only formulas in row 4 will be calculated.

Ken Johnson
 
Go Tools|Options|Calculation then select Manual then OK.

Then run a macro like...

Public Sub CalculateRow4()
Range("4:4").Calculate
End Sub

In this example only formulas in row 4 will be calculated.

Ken Johnson
Click to expand...

You could then set up a Change Event procedure that calls the CalculateRow4
whenever any of the cells in row4 change. By using named areas you could make it
easy to read.

In the Sheet VBA code

Private Sub Worksheet_Change(ByVal Target As Range)

Dim isect As Range

Set isect = Application.Intersect(Target, Range("Data"))
If Not (isect Is Nothing) Then
Range("Data").Calculate 'You could calc a different range here if required.
End If

End Sub
 
Back
Top