Offsetting formula results
 

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?

Offsetting formula results
 

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?

Offsetting formula results
 

Thank you that did the trick


"Norman Jones" wrote in message
...
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?