Log In
Register
Home
March 6, 2019
Offline
Hello together,
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
Offline
Hi Andi,
Not sure how you can change a cell, but at the same time not change the cell.
Why do you want to do this? If you can explain your intended result maybe we can come up with an alternative.
Phil
VIP
Trusted Members
June 25, 2016
Offline
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.
1 Guest(s)
