Will Edit|Cut instead of Edit|copy brake a link with Dependents on the
target destination, without replacing =?
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
Maybe you just want to Edit|Cut instead of Edit|copy???

Dmitry wrote:

I was wrong that Dependents will lose their precedents.
"Dmitry" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
...
Thanks Otto Moehrbach!
Dependents on the target destination will lose their precedents if I
override the target destination by pasting the array.
"Otto Moehrbach" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: .. .
One way is to change the formulas so that Excel will not recognize
them
as
formulas, do the copy and paste, then change them back.
Do this:
Select the range (the array) that you want to copy.
Click on Edit - Replace.
In the "Find what:" box, type "=" without the quotes.
In the "Replace with:" box type "Dmitry" without the quotes.
Click OK.
Copy and paste.
Now select the new range and reverse the process.
Done
HTH Otto
"Dmitry" wrote in message
...
Hello specialists!
How to copy an array to an array of the same size without changing
relative
cell references in the formulas?
Best regards,
Dima







--

Dave Peterson