Den 2006-02-18 02:03:22 skrev Ross Johnson <[EMAIL PROTECTED]>:
If you move a single formula, 99.99% of the time you do want it to move
unchanged, because the referenced cells have not moved. But when you
paste the cut cell into a range, you are probably creating a sequence or
an array:
E.g.
A1 =1
A2 =A1+1
Cut A2
Paste to A3 to A5
A3 =A1+1
A4 =A3+1
A5 =A4+1
I think this is usually what one would be intending to do. Although it
may still seem a little odd, because you would normally enter a formula
into A2 and then cut or copy A2 and paste to a cell range with A2 as the
first cell again. You wouldn't normally move it at the same time. But
then, if you do move it you want everything to work correctly. The way
it is now works both ways.
Well, I guess you wanted it to look like this:
A1 =1
A2 =A1+1
A3 =A2+1
A4 =A3+1
A5 =A4+1
I guess that is what would happen of you cut A2 and paste it to A2 to A5
instead of A3 to A5. But maybe that's exactly what you meant...
Johnny
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
