Hello folks,
The below code loops through several .xlsm workbooks, calling the Startx macro for each workbook.
Most times it works perfectly, but, eventually, I get the following error:
Run-time error '9':
Subscript out of range
Then on this same message box there are the buttons: End, Debug and Help
When I click on Debug, it highlights this part of below code:
Then I simply need to click on Play button, and it continues the macro until it completes successfully.
In order to try to fix this issue I tried to minimize the screen of AllWorkbooks macro, but it did not work.
Does anybody has any idea on what I need to do to solve this?
Bookmarks