Posted 8 September 2017, 4:48 am EST
Hi,
Suppose I set a formula on .Cell(0,2).Formula = "A1+B1". Also, suppose I have .Cell(0,0).value = 10 and .cell(0,1).value=20.
In this case .Cell(0,2) will have 30 as a value.
Now suppose the user types in a number into .Cell(0,2) ... 50 for example. The next time the sheet is recalced it's set back to 20.
How can I make the 50 sticky?
Thanks ... Ed