title: Selecting multiple sheets using a range
body: <p>I have sheet names in cells C2 to C5, which are dynamic. I would like to select them at the same time using VBA.</p>
  <p>The only way I have found uses arrays and &quot;hard-coding&quot; the sheet names.</p>
  <pre class="lang-vb prettyprint-override"><code>Sub ssheets()
      Worksheets(Array(&quot;Sheet2&quot;, &quot;Sheet3&quot;,&quot;Sheet4&quot;,&quot;Sheet5&quot;)).Select
  End Sub
  </code></pre>
  <p>I would like something that uses <code>Range(&quot;C2:C5&quot;)</code> so that I can select the relevant sheets without having to type in &quot;Sheet2&quot;, &quot;Sheet3&quot;,&quot;Sheet4&quot;,&quot;Sheet5&quot; etc.</p>