Hi JLGWhiz,

Myabe I missed something but following your suggestion produced
"=Sheet1!$A$5" in cell Sheet2!A5.

I was after "=Average(Sheet1!A3,Sheet1!A4)" ...... not the value or the link

Cheers

"JLGWhiz" wrote:

Seemed to work ok with CopyPasteSpecialPasteLink


"warrenshooter" wrote in message
...
I have two sheets (Sheet1 and Sheet2)

In cell A5 in Sheet1 I have a formula "=Average(A3,A4)"

I would like to copy this formula to cell A5 in Sheet2 but have the
formula
still reference Sheet1. In cell A5 in Sheet2 the formula should be
"=Average(Sheet1!A3,Sheet1!A4)"

If Sheet1!A5 was originally "=Average(Sheet1!A3,Sheet1!A4)" then there is
no
problem.

Would love to hear the answer. It must be something simple.

Warren