Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do change formula to permanent data?
I have created a simulation and satisfied with its results but I can't
stopped excel from recalculating unchanged cells even if I only want it to calculate new cells |
#2
|
|||
|
|||
You can select all, copy, paste special, values...probably to a new
spreadsheet. Carole O "Wendron Gordon" wrote: I have created a simulation and satisfied with its results but I can't stopped excel from recalculating unchanged cells even if I only want it to calculate new cells |
#3
|
|||
|
|||
Hi,
i find that this works ok. Sub lowercase() Dim Oldv, Newv Oldv = ActiveCell.Value Newv = Format(Oldv, "< ") ActiveCell.Value = Newv it changes to lowercase though. not sure how to stop that but it does the following. select the cell containing the calculated formula issue routrine and it changes. If you can modify this not to change to lower case then please update me. Nigel "Carole O" wrote: You can select all, copy, paste special, values...probably to a new spreadsheet. Carole O "Wendron Gordon" wrote: I have created a simulation and satisfied with its results but I can't stopped excel from recalculating unchanged cells even if I only want it to calculate new cells |
#4
|
|||
|
|||
Hi again,
this should work: Sub special() Selection.Copy Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False End Sub select cell in question and run macro. done. Nige "Nigel" wrote: Hi, i find that this works ok. Sub lowercase() Dim Oldv, Newv Oldv = ActiveCell.Value Newv = Format(Oldv, "< ") ActiveCell.Value = Newv it changes to lowercase though. not sure how to stop that but it does the following. select the cell containing the calculated formula issue routrine and it changes. If you can modify this not to change to lower case then please update me. Nigel "Carole O" wrote: You can select all, copy, paste special, values...probably to a new spreadsheet. Carole O "Wendron Gordon" wrote: I have created a simulation and satisfied with its results but I can't stopped excel from recalculating unchanged cells even if I only want it to calculate new cells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS? | Excel Worksheet Functions | |||
formula to determine the first column containing any data | Excel Worksheet Functions | |||
Formula to Extract Data from a Table | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |