Intermittent VBA error on pasting

Hi I have the following:

Please Login or Register  to view this content.

Which works sometimes but then will come up with an error saying Microsoft Excel cannot paste the data error 1004. If I click debug then it highlights:

Please Login or Register  to view this content.

It's been fine for ages so don't know why I'm suddenly getting an error. If I click end then I can manually paste link with no issue.

Hi,

Just an untested guess, but try adding the line in red below:

Please Login or Register  to view this content.

Lewis

Hi thank you.

I won’t be able to try this until next week but appreciate the suggestion.