#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 |
#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 |
All times are GMT +1. The time now is 08:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com