title: Specifying worksheet name required when identifying a cell by name in Excel 2007
body: <p>Initially asked in SuperUser: <a href="https://superuser.com/questions/206822/specifying-worksheet-name-required-when-identifying-a-cell-by-name-in-excel-2007">https://superuser.com/questions/206822/specifying-worksheet-name-required-when-identifying-a-cell-by-name-in-excel-2007</a>.</p>
  
  <p>I don't know if this is a change in the version, but in 2003 this used to work in Access VBA:</p>
  
  <pre><code>Dim xlSheet As Excel.Worksheet
  xlSheet.Range("RangeName").Value = 100
  </code></pre>
  
  <p>Previously I did not need to identify the worksheet because "RangeName" was unique. Is Excel 2007 not considering this a unique value and requires that the worksheet be specified?</p>
  
  <p>[EDIT] Here is the error in Access 2007 VBA:  </p>
  
  <blockquote>
    <p>"Error 1004 (Method 'Range' of object '_Worksheet' failed." Trying to avoid naming the worksheet.</p>
  </blockquote>
  
  <p>I used the Name Manager in Excel. The name is unique and the scope is workbook. </p>
  
  <p><img src="https://i.stack.imgur.com/9XDNJ.jpg" alt="alt text"></p>
  
  <p>When I tried to Edit Name, it does not allow the scope to be changed.
  <img src="https://i.stack.imgur.com/PWSOI.jpg" alt="alt text"></p>
  
  <p>Note: This workbook is Template that allows macros and the names are a mess. </p>