Hi All,

This isn't a programming issue but a Formula issue.

I want to copy a group of formulas from 1 workbook to another. When I do,
it references the prior workbook. Is there a way to paste a group of
formulas but have them refence the sheets & cells of the current workbook?

I tried paste special - Formulas

Thanks
chad

You can re-direct links after the fact using EditLinks and changing the
source workbook to current one.

Or you can edit before copying.

EditReplace

What: =

With: ^^^

Replace all.

Copy to new workbook then reverse the edit/replace.

Close old workbook without saving.


Gord Dibben MS Excel MVP

On Fri, 8 Jan 2010 09:18:24 -0800, "Chad Cameron"
remove NOT wrote:

Hi All,

This isn't a programming issue but a Formula issue.

I want to copy a group of formulas from 1 workbook to another. When I do,
it references the prior workbook. Is there a way to paste a group of
formulas but have them refence the sheets & cells of the current workbook?

I tried paste special - Formulas

Thanks
chad