Once your formula has returned the result, copy it and then Edit > Paste Special > Values.
How will it get there in the first place without human intervention? You want some event to trigger a calculation and then store the result in a cell?
What formula is it?
What event will trigger it?
Perhaps
Code:Private Sub Worksheet_Calculate() With Me.UsedRange.SpecialCells(xlCellTypeFormulas) .Value = .Value End With End Sub
To use this, right click the sheet tab, select View Code and paste in the code.
Private Sub Worksheet_Calculate()
Cells(Rows.Count,"B").end(xlUp).Offset(1,0).Value = Range("A1").value
End Sub
Note, I may be too cautious here. I don't trust programmatic changes because I don't have experience with them, so having some other cell depend on the programmatically changed cell is another triggering event.Assuming that Cell A2 has the formula =A1 and A1 is the cell being remotely updated,