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?