When working with worksheets, 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 name of the Worksheets spelled correctly?
- Has the name of the sheet changed and not been updated in your code?
- Has the worksheet been deleted?
- Has the index you used to reference the sheet too large?
- If working with multiple workbooks, did you reference the wrong workbook?