Converting formulas to value - Advanced
Posted by Mary Beth on February 01, 2001 9:03 AM
I need to convert the cell references in a formula to its values. For instance, I have the formula
if(a1>b1, a1, b1)
I want to see in my cell: if(100>80,100,80) Obviously edit|past special|value is NOT what I want. Also, I need to do this using VBA because it will impact multiple spreadsheets (so the whole, highlight the cell reference and press F9 is not going to be the solution).
Alternatively, what if I need to subtract something?
if(a1>b1, a1-b1, b1)
I want to see: if(100>80, 100-80, 80)