When I do a Ctrl+End on your file, regardless of what is selected before I do it, I always end up at cell A1.


When I copied column widths only, the last cell became the same column as the last cell of the copied range's rightmost cell, or the same as the last cell column of the source sheet if the range I was copying the column widths from was wider than the used range (last cell). Note that there were column-widths changes in the source sheet to the right of the last cell column of that sheet; these column widths were copied over but the last cell on the new sheet was still to the left (column T instead of column V).


Make of it what you will!!


If your source sheet's last cell is in column XFD and you're selecting the whole top row or all the cells in the sheet, the last cell column will be the same as your source sheet's last cell column - so if you're doing that maybe you need only to copy a smaller range's colmn widths?