I can get :-
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False
to work.
But setting the active cell is not straightforward.
Workbooks("myBook").activate always works but
Cells(1, 1).select (and Cells(1, 1).activate) sometimes work but are both unreliable.
Can...