Select the entire formula in the formula bar.

Right click in the selection, and choose "Copy".

Hit <Enter.

Right click in J10, and choose "Paste".

And you're done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gary's Student" wrote in message
...
I would like to copy the formula in one cell to another without adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must be a
simple way to do this without resorting to VBA??

--
Gary's Student