Removing a formula from a cell once the result is in the cell
 

Is there a way to remove a formula from a cell and keep the result in the
cell immediately after the formula returns its result?

Would something like this require a Macro of some kind of knowledge of
writing VBA Code?

Thanks!!!!!!
--
Jim

Removing a formula from a cell once the result is in the cell
 

You can do this manually...

Select the cell with the formula
Goto the menu EditCopy
Then EditPaste SpecialValuesOK

Biff

"jpolzner" wrote in message
...
Is there a way to remove a formula from a cell and keep the result in the
cell immediately after the formula returns its result?

Would something like this require a Macro of some kind of knowledge of
writing VBA Code?

Thanks!!!!!!
--
Jim

Removing a formula from a cell once the result is in the cell
 

Hi Jim,
A formula will always return a result (a value), so you
will have to be more specific as to what value you want
to test for in a macro.

If you want to selectively change the cell value one
when another cell changes it's value without using
a formula then you probably want to look at using a
Change Event macro
http://www.mvps.org/dmcritchie/excel/event.htm


Not what you asked, but if you simply want to provide someone
with cell values for the entire worksheet or the entire
workbook without any formulas then you can easily
create a copy of the workbook for distribution without
any formulas using a standard macro.

Manually with Grouped Sheets, working on the copy not original
(Be very careful when working with grouped sheets)
http://www.mvps.org/dmcritchie/excel...nd.htm#grouped

Example to replace formulas for values in a selected range:
http://www.mvps.org/dmcritchie/excel...vert_to_values

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"T. Valko" [Biff] wrote...
You can do this manually...

Select the cell with the formula
Goto the menu EditCopy
Then EditPaste SpecialValuesOK

"jpolzner" [Jim] wrote...
Is there a way to remove a formula from a cell and keep the result in the
cell immediately after the formula returns its result?

Would something like this require a Macro of some kind of knowledge of
writing VBA Code?