Hi,
I have a macro that i run every day, and every day it has run smoothly no problem for over a month, today however it decided to break.
The issue seems to be Workbooks("workbookname").<Anything> seems to be throwing a subscript out of range error.
If i were to change this to Workbooks("workbookname.xls").<Anything> this seems to work, the question is, why would it now decide it can't run this code when it's been running successfully every day so far.
I can go in and change all this code but i would rather be able to get it running again how it used to.
Regards,
Andy
Bookmarks