Copying formulas

How can I copy a formula with cell references in a worksheet within a
workbook to another worksheet in another workbook without including the the
workbook reference that automaticly gets included when I paste the formula
in the new workbook.

Couple of ways:

Select the *entire* formula in the formula bar.
Right click in the selection and choose "Copy",
Then hit <Enter>
Then paste it anywhere you wish.

OR

"Unformulate" the formula by removing the equal sign.
Now it becomes simple text.
Copy and paste anywhere.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Hrider" <hrider@yahoo.com> wrote in message
news:eKndSjZgFHA.3776@TK2MSFTNGP10.phx.gbl...
> How can I copy a formula with cell references in a worksheet within a
> workbook to another worksheet in another workbook without including the
the
> workbook reference that automaticly gets included when I paste the formula
> in the new workbook.
>
>