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?