LOL - That too :-)
--
Regards
Ken.......................
"Ragdyer" wrote in message
...
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 !
--------------------------------------------------------------------------
-
"Ken Wright" wrote in message
...
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 :-)
--------------------------------------------------------------------------
--
"Ragdyer" wrote in message
...
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
|