title: Cannot reference sheet through sheet number/codename
body: <p>I have a problem in my vba when referencing some specific sheets number/codename. See below this working:</p>
  <p><code>Sheet37.Range(&quot;A3:A35&quot;).EntireRow.Hidden = False</code></p>
  <p>But this is not working:</p>
  <p><code>Sheet10.Range(&quot;A6:A14&quot;).EntireRow.Hidden = False</code></p>
  <p>For some reason, Excel can't reference this sheet and a few others, while I have no problem with most of the sheets in the workbook. Morever, I have retrieved a previous version from my file where the exact same code works totally fine.</p>
  <p>I really do not see a reason as to why this would happen so any help is more than welcomed.</p>
  <p>I also tried the following code within the sheet and it still does not work:</p>
  <pre><code>Sub Newfunction()
      Sheet10.Range(&quot;A6:A14&quot;).EntireRow.Hidden = False
  End Sub
  </code></pre>
  <p>Many thanks in advance</p>
  <p><a href="https://i.stack.imgur.com/v3Y8d.png" rel="nofollow noreferrer">Screenshot from running the code</a></p>
  <p>(Note that I manually blurred some sheet names)</p>