If there's only a single formula (or a limited number), I copy each from the
formula bar and paste into the formula bar.

If there are a lot, I'll select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$=
replace all

Now those formulas are just text.

Edit|copy
followed by Edit|paste

And then do a couple of edit|replaces to change those text strings back to
formulas

Select the range
edit|Replace
what: $$$$$=
with: =
replace all

In both the original worksheet and the newly pasted worksheet.

Rupert wrote:

How does one copy a formula from one workbook (WB) to another without the new
formula not referencing back to the orginal workbook? E.g. when I copy a
formula from WB1 that adds two cells in WB1 together and paste it into WB2
the formula now in WB2 still adds the 2 cells in WB1 and posts the result in
WB2. I want the just formula to be copied so that the two cells added are
from WB2. Paste Special doesn't help.
--
R H Ingram

--

Dave Peterson