Copying & Pasting Formula
 

Everytime I copy a row of formulas and paste them into another worksheet of
another workbook, it pastes linked to the other file. How do I get the bare
formula to paste without referencing the file they came from?

Connie Martin

First do an editreplace and replace the equal sign = with something like a=
then copy and paste, finally do a reverse replacement on all sheets involved

--

Regards,

Peo Sjoblom


"Connie Martin" wrote in message
...
Everytime I copy a row of formulas and paste them into another worksheet
of
another workbook, it pastes linked to the other file. How do I get the
bare
formula to paste without referencing the file they came from?

Connie Martin

Hey! Now that's cool! Thank you for such a clever idea!

Connie Martin

"Peo Sjoblom" wrote:

First do an editreplace and replace the equal sign = with something like a=
then copy and paste, finally do a reverse replacement on all sheets involved

--

Regards,

Peo Sjoblom


"Connie Martin" wrote in message
...
Everytime I copy a row of formulas and paste them into another worksheet
of
another workbook, it pastes linked to the other file. How do I get the
bare
formula to paste without referencing the file they came from?

Connie Martin