hi
Range("A1").PasteSpecial xlPasteValues
this will paste the formula as a value instead of a formula. I'm guessing
that when you paste into the new sheet the formula looses is references which
produces the #REF error.

Regards
FSt1

"Shell" wrote:

I am trying to copy the contents of a cell in another workbook. The problem
I have is that the source cell is the sum of many cells. This is causing me
problems. I get #REF instead of the cell data.

Any help would be appreciated.

Thanks
--
Shell