Hi Patrick,

Try:

'=============
Private Sub Worksheet_Calculate()
Me.Range("C29").Value = Me.Range("D29")
End Sub
'<<=============

This is worksheet event code and should be pasted into the worksheets's code
module (not a standard module and not the workbook's ThisWorkbook module):

---
Regards,
Norman



"Patrick Simonds" wrote in message
...
I would like to place the formula below in cell D29 and have the result
show in cell C29. There can be no formula in cell C29. Is this possible?