![]() |
#1
|
|||
|
|||
![]() I don't understand why the following causes an error: Put 0 in cells A1 and A2. Put the formula =A2 in cell A3. Cut cell A1 and paste it into cell A2. Cell A3 then shows a #REF! error. |
#2
|
|||
|
|||
![]()
What's in A2 and A3 after you paste?
|
#3
|
|||
|
|||
![]()
0 in A2; =#REF! in A3.
|
#4
|
|||
|
|||
![]()
Ohhhh...I see what happens. I suppose what is happening is that Excel now sees the reference to A2 in the formula as sort of disappearing. I know that doesn't make sense. Hopefully someone else will that can explain it better.
That's interesting! |
#5
|
||||
|
||||
![]()
You'll have to ask MS. Following site describes your error. As to why MS implemented it, I don't know
https://support.office.com/en-gb/art...1-92b0ec269e82 @ gebobs : long time no see , glad you're back . Still sore at the key?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
![]()
Yeah, I haven't had a lot of time lately. :-)
Quote:
|
#7
|
|||
|
|||
![]()
Ohhhh...Excel Key! Right.
No, I was never sore at the key. I vaguely remember some incident, but that water has long passed under my bridge. I pop in from time to time. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
BruceM | Word | 3 | 07-10-2015 04:33 AM |
Paste to a series of boxes with one paste? | BudVitoff | Misc | 0 | 11-27-2013 02:51 PM |
![]() |
tinfanide | Word | 6 | 03-06-2013 12:21 AM |
![]() |
Ulodesk | Word | 8 | 03-19-2012 01:57 PM |
![]() |
averagejoe | Word | 2 | 03-13-2012 05:40 PM |