If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rapid input Via datasheet | RudyR_Seattle | General Discussion | 4 | January 31st, 2005 01:33 AM |
Cannot change a formula | Richard F | General Discussion | 1 | January 18th, 2005 01:57 AM |
How do I get a cell to show the data and not the formula? | Chris | General Discussion | 1 | November 7th, 2004 09:52 PM |
How do I change data in one cell so other copies& vice versa | sedain | New Users | 3 | September 8th, 2004 10:07 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |