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