Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"Freezing" cell contents
At the end of each month, I want to "freeze" the results in various cells.
For example, if a cell using a formula results in "23" I want to change that cell FROM a formula TO the value "23" so that it doesn't change again in the future. (I know I could just type the result in, but I have many cells like this.) Any functions or macros to do this??? Thanks for the help. Larry |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"Freezing" cell contents
Larry
You can copy then Paste Special(in place)ValuesOKEsc If you want to use a macro to highlight and copy/paste special all formula cells try this. Sub SELECT_FORMULAS() On Error GoTo errormessage With Selection Selection.SpecialCells(xlCellTypeFormulas, 23).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False End With Exit Sub errormessage: MsgBox "No Formulas in Range" End Sub Gord Dibben MS Excel MVP On Mon, 23 Oct 2006 10:30:17 -0700, "Larry E." wrote: At the end of each month, I want to "freeze" the results in various cells. For example, if a cell using a formula results in "23" I want to change that cell FROM a formula TO the value "23" so that it doesn't change again in the future. (I know I could just type the result in, but I have many cells like this.) Any functions or macros to do this??? Thanks for the help. Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |