I love the compactness of the code. I see I've still got a lot to learn. Unfortunately I get the same error form line .Range("A1").PasteSpecial
As before I can take the "Debug" option and successfully Paste using the Clipboard. However, I note that Ctrl + V does not work. The sheet is not protected and as no other code is involved I'm at a loss.