Hi George

Instead of copying the cell, then pasting, highlight the cell, but then
mark the formula in the formula bar at the top of the sheet and copy
that, then press escape.
Now, navigate to your destination cell and paste.

--
Regards

Roger Govier


"George" wrote in message
...
I am trying to copy a formula from one cell to another but when I paste
it into the new cell the column and row number changes to the new
cell that I am pasting it into. How can I make it stay the same as
the
original ?

Thanks - George