copy/paste
 

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

copy/paste
 

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

copy/paste
 

Windows("Book2").Activate
Range("Z100").Select
Selection.Copy
Windows("Book1").Activate
Range("A1").PasteSpecial Paste:=xlPasteValues
--
Gary''s Student - gsnu200750


"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