I have a rather complex Worksheet that I'm putting together to calculate Life-TIme-Value. I need a macro that I've started to write but it doesn't work. The Macro is in Module 1, called Sub Formula_to_Absolute_Click(
). What it is suppose to do is take any value (created by the formulas) and change it from formulas to "absolute values" and by pressing the button again, it needs to return to the original formulas. The Range should be E5:Z9.
That's it! Much thanks in advance.