Conclusions for "Copy Insert thingy"

I think I can explain the Observed rules discussed using Interception Theory
http://www.excelfox.com/forum/showth...on-and-VLookUp
https://www.excelforum.com/tips-and-...d-vlookup.html
A good graphical explanation will have to wait until I have access to and am confident in a good graphical presentation software.
In words for now:
The help matrix in the case of 1a) is in the dimension of the given Range due to the full encompassing of the copy Range limited to multiples of the help matrix for interception of that help matrix. Valid coincidentalled matching vectors by the pseudo Array formulaed rows then columns screen updating will limit to those locking on that grid of repeated copy Range. This reduces to the single copy Range without a valid intersect in the two dimensions.

In the case of 1b) the reduction of any one dimension below copy Range will result in the repeated extended copy for that dimension in the other in the help matrix. This will allow the interception in that dimension for any multiple.

The reason why a shift resulting in a split initial copy Range errors for selected Range other than that on the Top left intersect is due to the forced breaking of any intersections in place caused be the shift and resultant split



I think I would avoid the "Copy Insert thingy".
It is bad enough that the Range.Insert Method is not really, what it might appear to be, or is attempted to be explained to be.


Conclusions from Range.Insert Method.
Clearly there is a lot more to it , when one investigates it fully. There appears no documentation to many of the characteristics that I have found.
So it is a partially not known and undocumented thing.
So I would not use it.



https://powerspreadsheets.com/excel-vba-insert-row/
https://msdn.microsoft.com/de-de/vba...t-method-excel
https://msdn.microsoft.com/en-us/lib...ffice.11).aspx
https://msdn.microsoft.com/de-de/vba...sgbox-function