Offsetting formula results

[Patrick Simonds]

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?

 

[Norman Jones]

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):

 

[Patrick Simonds]

Thank you that did the trick

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):