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