If you paste to the formula bar rather than the cell you can copy one formula
without adjustment of addresses.

If you would like a macro to do this see
Right Click Menus (Context Menus) in Excel
http://www.mvps.org/dmcritchie/excel/rightclick.htm
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ineluctable" wrote in message ...
Worked like a charm.

Thanks

"Dave Peterson" wrote:

If you're doing one cell, you could copy from the formulabar, then paste into
the formulabar. You'll have to adjust the formula yourself.

If you're doing lots...
Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Do your copy|paste

Then reverse it (in both worksheets/workbooks):

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

Since you're copying text, you may have to change the ranges.

Ineluctable wrote:

How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .

--

Dave Peterson