#REF! after cut and paste XL2K

M

MIke

I have a reference in sheet2 to a list of cells in sheet1.
Everytime I paste numbers into the referenced cell of
sheet1, sheet2 gives me the #REF! error. MSExcel help says
the fix is to hit the undo button, but that is not an
option. I want to be able to paste values into sheet1 and
have the reference in sheet2 update its value. Is this
easily possible? The formula that I'm using in sheet2 is
='sheet1'!D8

Any help would be greatly appreciated.

Thanks in advance.
 
D

Dave Peterson

Can you do a copy|paste instead of Cut|paste? Then go back and clean up your
original range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if statement, change cell only if true 4
how can I copy/paste a formula that skips 27 rows? 0
Why does "cut and paste" cause #REF! errors? 4
Macro to change referenced column to the next one 1
Need help to fix vlookup function in macro 1
Excel formula referencing cells 4
index and match, then subtract, divide and add for my final answer 3
using a cell's reference to return a value. 3

Top