I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a "Run-time error '9': Subscript out of range" error. I have no idea what is causing it. It is stoping at the beginning of a new sub. The code says:
Windows("All Same Store Rate Plan Production.xlsx").Activate 'failure is here sheetNo1 = ActiveWorkbook.Worksheets.Count
I can promise, the spreadsheet it is referring to is open. It is named correctly. Can anyone offer some ideas as to why this error is coming up?
In advance, thanks for your help.