Script Error

G

Guest

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?
 
H

Harald Staff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP & IF used with > or < 7
Cumulative Timesheet Entries 5
Countif Function?? 3
How do I count repeat Occurrences 5
how many times a particular day of the week appears in a given month 4
Timesheet with many conditions 4
Calculate Goal each day 7
Outlook 2007 - Difficult calendar entry 4

Top