Thread: Script Error
View Single Post
  #1   Report Post  
Mike
 
Posts: n/a
Default 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?