For VBA code

Sub CopyFormula()
activeCell.Formula = Range("A4").Formula
End Sub

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
If you change
A4: =$A$3

then if you copy A4, the cell reference won't change.

is that what you want?

--
Regards,
Tom Ogilvy

"jiang" wrote in message
...
thanks in advance

for instance, A1=1,A2=1, A3=A1+A2, A4=A3

now if in A6 cell, I'd liket to make a copy from A4 without changing
reference, the result should still be =A3, how could I make it ?

jiang