March 6, 2019
is there a way to overwrite a cell with the value function but keep the formula used in this overwritten cell?
Like there is a blank cell with a formula in a worksheet and I overwrite it with for example
Workorder.Sheets("MOD_V.XLS").Cells(i, 36).Value2 = TSN
But it overwrites the formula in the background as well? I also tried the .formula but of course it takes the formula from the cell where I get my value then. But in this there is no formula.
So is it possible to keep it and just overwrite the value not the formula?
October 5, 2010
June 25, 2016
If you only want to add a value and retain the original formula in the same cell, then maybe you can try using the N() function.
Something like =SUM(A1:A3)+N("SUM(B1:B3)") where the portion in red is the original formula but commented out.
NOTE: It only work for formulas (the portion in blue) that return numeric results.