title: Setting a Worksheet using both the worksheet name as defined in the object explorer with the workbook definition
body: <p>So there are a few ways to set a worksheet in Excel.</p>
  
  <pre><code>set WS = Sheets("Name Here!")
  set WS = WB.Sheets("Name Here!")
  set WS = shNameOfTheSheetObject
  </code></pre>
  
  <p>However, there doesn't seem to be a way to do:</p>
  
  <pre><code>set WS = WB.shNameOfTheSheetObject
  </code></pre>
  
  <p>I'd like to know how, if it's possible, I can get this type of reference to work. I like being very, very explicit with my code (Perhaps too much so), and it'd be useful to know if I have multiple workbooks open that I'm handling. </p>