This might be some sort of follow up question from Ken Runge post "Cop
formula between Workbooks" from Oct-23-2003. I would like to copy som
formulas from one workbook to another without getting a reference t
the original workbook

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Syslock,

This happens, I think, where there are cell references to other sheets. One
way is to copy the text of the formula (drag across the text in the formula
bar), instead of the cell. Cell references won't adjust relatively when you
paste, though, though copying the pasted formula in the target workbook will
do so, so you can still make it work.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Syslock" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> This might be some sort of follow up question from Ken Runge post "Copy
> formula between Workbooks" from Oct-23-2003. I would like to copy some
> formulas from one workbook to another without getting a reference to
> the original workbook.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

Syslock,

Don't copy the cell. Select and copy the formula text in the the
"Formula Bar" above the worksheet. At least that's what I do.

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden

"Syslock" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> This might be some sort of follow up question from Ken Runge post "Copy
> formula between Workbooks" from Oct-23-2003. I would like to copy some
> formulas from one workbook to another without getting a reference to
> the original workbook.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

One method is to select the range of formulas in book1 and Edit>Replace

what: =
with: xx=

Do your copy over to book2 then reverse the Edit>Replace

Gord Dibben XL2002

On Tue, 11 Nov 2003 09:49:03 -0500, Syslock
<(E-Mail Removed)> wrote:

>
>This might be some sort of follow up question from Ken Runge post "Copy
>formula between Workbooks" from Oct-23-2003. I would like to copy some
>formulas from one workbook to another without getting a reference to
>the original workbook.
>
>
>------------------------------------------------
>~~ Message posted from http://www.ExcelTip.com/
>~~View and post usenet messages directly from http://www.ExcelForum.com/

And how about to copy a register from one worksheet to another where
also get the reference to the original

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com