Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#REF! error
How come the following occurs:
In cell A1, I have the word "NAME" entered (w/o the quotes) In cell B1, I have "=A1" typed and all is perfect...."NAME" appears in B1. Then, if from cell C1, where "ROBIN" is typed, I hit "CTRL C" and "CTRL V" into cell A1...and all is fine...in cell B1, I instantly get "ROBIN". BUT, IF, INSTEAD, I TYPE IN CELL C1 "CTRL X" and then "CTRL V" into cell A1... ALL IS NOT FINE... B1 appears #REF1" error...because instead of copying and pasting into A1, I X'ed out and pasted, the error, "#REF!" appears in B1. Please explain and thanks, FKulchar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#REF! error
When you cut data from a location, you sever the relative references so that
when you paste it to the new location the links to that cell cannot make the connection and result in the #REF! error. Don't ask me why. That was the way MS designed it. "F. Lawrence Kulchar" wrote: How come the following occurs: In cell A1, I have the word "NAME" entered (w/o the quotes) In cell B1, I have "=A1" typed and all is perfect...."NAME" appears in B1. Then, if from cell C1, where "ROBIN" is typed, I hit "CTRL C" and "CTRL V" into cell A1...and all is fine...in cell B1, I instantly get "ROBIN". BUT, IF, INSTEAD, I TYPE IN CELL C1 "CTRL X" and then "CTRL V" into cell A1... ALL IS NOT FINE... B1 appears #REF1" error...because instead of copying and pasting into A1, I X'ed out and pasted, the error, "#REF!" appears in B1. Please explain and thanks, FKulchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |