Copy without Adjustment

[Gary's Student]

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??

 

[Ragdyer]

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.

 

[Ken Wright]

And if you have range of cells to do this to, then select the range and do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit /
Replace / Replace %% with =.

 

[Ragdyer]

Then, if you want the original formulas to still work at their original
location, go back to them and also revert the change back to it's original,
while the Edit - Replace dialog window still remembers the replace
settings.<g>

 

[Gary's Student]

Thank you
--
Gary's Student

And if you have range of cells to do this to, then select the range and do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit /
Replace / Replace %% with =.

 

[Ken Wright]

LOL - That too

--
Regards
Ken.......................

Then, if you want the original formulas to still work at their original
location, go back to them and also revert the change back to it's original,
while the Edit - Replace dialog window still remembers the replace
settings.<g>
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

And if you have range of cells to do this to, then select the range and do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit /
Replace / Replace %% with =.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission
--------------------------------------------------------------------------
--



--------------------------------------------------------------------------

benefit

!

--------------------------------------------------------------------------

be