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...
Is there a way to overwrite the formula in a cell with its value from within a user defined formula?