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" <[email protected]> skrev i melding
news:[email protected]...
> 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?