Refusal of Excel to recognization Worksheet name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one Workbook that has a unique problem. When I attempt to access it from code in a module with the name of the sheet or "Sheet1", I get a <subscript out of range> error. I can access when I use the number (provided it is the first sheet). The code is

With Worksheets("Sheet1") ' gets me <subscript out of range

With Worksheets(1) ' work

This same sheet will not run a function attached to that sheet or from a module

Is there some switch that needs to be changed?
 
John

John H said:
I have one Workbook that has a unique problem. When I attempt to access
Click to expand...
it from code in a module with the name of the sheet or "Sheet1", I get a
With Worksheets("Sheet1") ' gets me <subscript out of range>
Click to expand...

You don't have a worksheet named Sheet1. Make sure you're spelling it
correctly. Less likely is that it's not a worksheet, but a chart sheet.
With Worksheets(1) ' works

This same sheet will not run a function attached to that sheet or from a module.

Is there some switch that needs to be changed?
Click to expand...

What is a "function attached to that sheet"?
 
Back
Top