Script Error
A user at my office has been using the same Excel spreadsheet for quite some
time. Recently, she has been receiving a Run-time error when attempting to print the spreadsheet. The error is as follows: Run-time Error €˜9: Subscript out of range When in debug the following line is highlighted: Sheets(Array("MONDAY", "TUESDAY", "WEDNESDAY", "THURSDAY", "FRIDAY")). _ Select Any idea what could be causing the problem? |
Hi
One or more sheets is renamed, deleted or hidden. Sheets with those exact names must all exist and be selectable in the file. HTH. Best wishes Harald "Mike" skrev i melding ... A user at my office has been using the same Excel spreadsheet for quite some time. Recently, she has been receiving a Run-time error when attempting to print the spreadsheet. The error is as follows: Run-time Error '9': Subscript out of range When in debug the following line is highlighted: Sheets(Array("MONDAY", "TUESDAY", "WEDNESDAY", "THURSDAY", "FRIDAY")). _ Select Any idea what could be causing the problem? |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com