File doesn't recognize itself anymore

Hi, all.

I have a macro that has been in use for several years now. I maintain it and update it, and can usually spot and fix bugs quite easily. Today would prove different.

In the macro, the following code exists:

Please Login or Register  to view this content.

Just today it gives the Error '9': Subscript out of Range error. I had not worked on the file for several months, and it is used daily so it was working just fine. But now that line doesn't execute anymore.

I've checked and rechecked the spelling of the filename, made sure that someone didn't save it with any accidental spaces in the name, checked spelling in the code as well, but now I am at a loss.

I haven't a clue why it won't execute. Any help would be greatly appreciated, and any insight as to the nature of this problem, too.

I have to reference the workbook and worksheet in such a manner because there are multiple workbooks open at runtime, since it uses data from other workbooks.