Dear Tom

Thanks a lot, actually I want to copy formula without changing reference
from seleced cells, which looks like 'cut\paste', but previous cells dont'
change, I couldn't do it in 'copy/special paste'.

I just start to work now, and will try vba code you wrote, thanks again.

Best wishes
jiang

"Tom Ogilvy" wrote:

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