title: Select range in a particular sheet in excel vba
body: <p>I have a question about selecting a range in a particular sheet using excel vba. </p>
  
  <p>I don't know why the following is not working:</p>
  
  <pre><code>Thisworkbook.Sheets("N&amp;A").Range("B4:F16").select
  </code></pre>
  
  <p>However this works:</p>
  
  <pre><code>Thisworkbook.Sheets("N&amp;A").Activate
  ActiveSheet.Range("B4:F16").Select
  </code></pre>
  
  <p>The VBA code is programmed on "N&amp;A" sheet.</p>
  
  <p>Could anyone let me know what could be the reason?</p>
  
  <p>Thank you!</p>