CTRL X...CTRL V...Why does it NOT work?

  • Thread starter F. Lawrence Kulchar
  • Start date
F

F. Lawrence Kulchar

In CellA1, I have 100
In Cell B1, I have =A1*2

A B
1 100 =A1*2

Question: WHY IF I "CUT" AND PASTE A NEW VALUE INTO A1, DOES THE ERROR,
#REF!, in cell B1, OCCUR?
Note: If I copy and paste, there is Not a problem. Only, when I cut and paste.

Please explain?

Thanks,

FLKulchar
 
F

FARAZ QURESHI

"Cut" refers to totally "move" a cell to a new address and remove the former
one. So, when a cell is completely removed no reference can be made to the
same as it no longer exists!
 
F

FARAZ QURESHI

Similar example can be understood as a formula in B2 as "=B1" and then
completely deleting the row by:
Alt+E, D, R, ENTER
#Ref error would result because the former B1 no longer exists!
 
F

FLKulchar

Thank you!!!!
FARAZ QURESHI said:
Similar example can be understood as a formula in B2 as "=B1" and then
completely deleting the row by:
Alt+E, D, R, ENTER
#Ref error would result because the former B1 no longer exists!
Click to expand...
 

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

How to make Ctrl-C, ctrl-V work in Office 2007 1
Target cell reference moves when target is cut and pasted 5
CTRL C and CTRL V gone! 1
copy and paste the cell with formula ="1" 3
Ctrl + V & Ctrl + S & Ctrl + X etc. etc. 3
How can I transpose reference cells by Auto-fill? 3
Why does "cut and paste" cause #REF! errors? 4
The Relative Macro 6

Top