Runtime Error 1004, code previously worked fine

[Eatmybrain]

Hi

Apologies if this has been asked elsewhere.

I have the following code:

Please Login or Register  to view this content.

Which until today worked fine, however when it runs it brings up a runtime 1004 error at the highlighted line. I've tried all I know but can't get it to work. As mentioned is worked fine until today which is odd I feel!

Thanks in advance

[Eatmybrain]

In fact the code works fine in another (older) workbook, but doesn't in the new one.