| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL X...CTRL V...Why does it NOT work?
Thank you!!!!
"FARAZ QURESHI" wrote in message ... 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! -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: "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! -- Best Regards, FARAZ A. QURESHI "F. Lawrence Kulchar" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use CTRL key inside a macro IE CTRL + ; | Excel Worksheet Functions | |||
| I can't get the Undo to work even using ctrl z | Setting up and Configuration of Excel | |||
| Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) | |||
| How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel | |||
| Ctrl + " Doesn't work | Excel Discussion (Misc queries) | |||
Hybrid Mode
