View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default CTRL X...CTRL V...Why does it NOT work?

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