title: Keep getting "Run-time error '1004': Select method of Worksheet class failed when trying to select a worksheet
body: <p>What I really need is a way to select multiple worksheets in a workbook based on index and/or location in the tab lineup. However, even the simplest select-by-index code is returning this frustrating error.</p>
  
  <p>Here's the simplest code that still returns the error:</p>
  
  <pre><code>Sub testselect()
  Worksheets(1).Select
  End Sub
  </code></pre>
  
  <p>And here's the gist of what I'd like to make work, but probably won't even after I solve this frustrating error:</p>
  
  <pre><code>Sub testselect2()
  Worksheets(Array(Worksheets(1), Worksheets(2), Worksheets(3), Worksheets(4))).Select
  End Sub
  </code></pre>