Copy over cell that is part of a formula error
Copy over cell that is part of a formula error
(OP)
Is there any way to avoid the #REF! error if you drag the content of one cell into another cell, and the destination cell is a reference to a formula (and the cell containing the formula now gives #REF! error as a result)? And yes this question is as easy and basic as it seems but I don't have the answer.
It doesn't happen if I hold down CTRL while dragging, but then I have to go back and delete the cell content from the original cell I was dragging from.
It doesn't happen if I hold down CTRL while dragging, but then I have to go back and delete the cell content from the original cell I was dragging from.





RE: Copy over cell that is part of a formula error
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize
RE: Copy over cell that is part of a formula error
It doesn't appear to be possible in Excel, I have to copy it down then go back and delete the original value every time.
RE: Copy over cell that is part of a formula error
RE: Copy over cell that is part of a formula error
"=Sum(range:range)" and not "=Sum(D8+E9+F10+E8...etc) or it will trigger the error when dragging contents.
RE: Copy over cell that is part of a formula error
It's much safer to copy and delete, or delete and re-type.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/