title: Nested With Statement hierarchy
body: <p>I've come across this a couple of times recently and was just curious if there was an easier way to do this...</p>
  
  <pre><code>With Activeworkbook
    'Do Stuff
    With .Sheets(1)
      'More stuff Done
      '...
      'But now I need to refer to or pass the Sheet in the last With Statement
      SomeFunctionAnswer = SomeFunction Activeworkbook.Sheets(1)
    End With
    'Yet more stuff Done
  End With
  </code></pre>
  
  <p>Does it have to be fully written out, or is there some way of notating it that makes it easier/cleaner?  Perhaps there is some sort of property or method to pass itself for just this instance?  What about referring to a property or method from the higher With?</p>
  
  <pre><code>SomeFunctionAnswer =  SomeFunction .Self  '???
  'OR
  SomeFunctionAnswer =  SomeFunction .Parent.Name  '???
  </code></pre>
  
  <p>Hope that makes sense...</p>