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!

I don't think that can be done.
Alan.
<David_Matano@agilent.com> wrote in message
news:dde9811f-970a-4252-b028-c3c6d0f253a3@w7g2000hsa.googlegroups.com...
> 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.
"Alan" <alan111@ntlworld.com> wrote in message
news:OEzRt4lqIHA.3900@TK2MSFTNGP05.phx.gbl...
>I don't think that can be done.
> Alan.
> <David_Matano@agilent.com> wrote in message
> news:dde9811f-970a-4252-b028-c3c6d0f253a3@w7g2000hsa.googlegroups.com...
>> 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!
>

On Apr 30, 9:54 am, David_Mat...@agilent.com wrote:
> 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!

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

On Tue, 29 Apr 2008 21:57:12 -0700 (PDT), Ken Johnson <KenCJohnson@gmail.com>
wrote:

>On Apr 30, 9:54 am, David_Mat...@agilent.com wrote:
>> 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!
>
>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

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
--
Dave Mills
There are 10 type of people, those that understand binary and those that don't.