**Problem Description**

I have a custom formula that I wrote, but it takes a while to calculate the answer, and since excel updates function values (When you activate the workbook, or re-open the workbook, etc.), I can't have it re-running the function.

I tried calling a Sub process to copy the cell and paste values (Replace a formula with its result), but it returns `=#VALUE!`

. Probably something to do with circular references...

**Question**

Is there a way to overwrite the formula in a cell with its value from within a user defined formula?