freezing formulas after calculation

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

Guest

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
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freezing calculation 4
Cell showing formula instead of date 6
Formula problems 2
Formulas only calculate a result when there is matching data in ce 2
Blank cells 1
backing up formulas in sheet coding? 2
Calculating Monthly returns based on Dates 4
Formulas not calculating - Calculation is on Automatic & I pressed 2

Back
Top