When working with workbooks, you may get Run-Time Error:9. That is, the following message box may pop up during execution:
Tips for debugging this error:
- Is the workbook you are referencing currently closed?
- Did you misspell the name of the workbook?
- Are you trying to reference a new workbook that has not been explicitly saved for the first time?
- Are you running two instances of Excel?
- Did you pass an index that is greater than the number of workbooks open?