VBA dim ws as worksheets (not worksheet)
<p>OK so, I know I can do this:</p>

<pre><code>Dim ws as worksheet
Set ws = thisworkbook.worksheets("Sheet1")
</code></pre>

<p>and then do my fancy stuff with the <code>ws</code> worksheet object</p>

<p>I also know I can <code>Dim wss as worksheets</code> and that using <code>worksheets("Sheet1")</code> returns the worksheet object. So why doesn't the following work?</p>

<pre><code>Dim wss as worksheets
Dim ws as worksheet
Set wss = thisworkbook.worksheets
Set ws = wss("Sheet1")
</code></pre>

<p>I've also tried:</p>

<pre><code>Dim wss as worksheets
Dim ws as worksheet
Set ws = thisworkbook.wss("Sheet1")
</code></pre>

<p>but the latter just looks like I'm trying to rename/shorten "worksheets" which seems totally wrong. I'm trying to get the worksheets of a workbook in to one worksheets object called wss. This is more about trying to understand the heirachy than anything but for functional purposes I'm trying to get wss to encompass all worksheets from workbook x so I could just do <code>ws = wss(1)</code> instead of saying <code>set ws = wb.worksheets(1)</code></p>

<p>Is that even possible or am I misunderstanding the worksheets/ worksheet relationship?</p>