Thread: Refusal of Excel to recognization Worksheet name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John H[_4_] John H[_4_] is offline
external usenet poster
  
Posts: 9
Default Refusal of Excel to recognization Worksheet name
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?
Reply With QuoteReply With Quote