freezing formulas after calculation

P

PTW

I've tried manually calculating and it won't work because as I move down the rows it will manually calculate all formulas within sheet. I'm adding information to target cells in which the formula cells are pulling from. Then I need to keep changing the target cells without altering the prior cells calculations. Does this make sense
 
P

Peter Atherton

You can do it with macros by setting the range to
calculate.

Sub ManCalc()

With Application
.Calculation = xlManual
.MaxChange = 0.001
End With
Range("H4:H6").Select
Selection.Copy
Range("F4").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("F7").Calculate
End Sub

You can reset the calculation at the end to something like
xlAuto

Regards
Peter
-----Original Message-----
I've tried manually calculating and it won't work
Click to expand...
because as I move down the rows it will manually calculate
all formulas within sheet. I'm adding information to
target cells in which the formula cells are pulling from.
Then I need to keep changing the target cells without
altering the prior cells calculations. Does this make
sense?
 
Top