On error and paste.special

[richarddawson]

I have a sub which starts with an On Error GoTo and then continues to use a PasteSpecial.
(I can paste code if required, but I suspect there may be an easy answer from someone here!)

Now if there is nothing to paste it does not go to the label but just stops at the PasteSpecial.

I suspect this is a system thing. I would welcome any comments.

I am using 64 bit 365.

 

[RoryA]

Not much I can suggest since that code should work - i.e. either error, or paste.