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/fillhand.htm#grouped
Example to replace formulas for values in a selected range:
http://www.mvps.org/dmcritchie/excel/join.htm#convert_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 Edit>Copy
Then Edit>Paste Special>Values>OK
"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?
