title: VBA Range.Parent Navigation between different workbooks
body: <p>I am developing an application in MS Excel 2010, and I'm using VBA to create some drop downs.
  I am trying to create a robust dynamic function that is able to do operations on Worksheets, (different tabs) based on the current tab. </p>
  
  <p>For example I have tabs: <code>A, B, C, D, E</code></p>
  
  <p>If I am on <code>Worksheets("C")</code>, I want to pull values from the worksheet right before it, <code>Worksheets("B")</code>. If I am on <code>Worksheets("D")</code>, then I want to operate on values from <code>Worksheets("C")</code> etc... </p>
  
  <p>I don't want to create a long hard-coded function that does a bunch of comparisons to see which is the current worksheet, and fetch values that way. </p>
  
  <p>I am currently getting the name of the current range as such.  </p>
  
  <pre><code>        Worksheets(someRange.Parent.Name)
  </code></pre>
  
  <p><strong>I'd like something like</strong>: <em>(But, this is the incorrect syntax...)</em></p>
  
  <pre><code>        Worksheets((someRange.Parent - 1).Name)
  </code></pre>
  
  <p>My question is, given a current Range, <code>someRange</code> how do I refer to other worksheets? What is the correct syntax? </p>
  
  <p>Thank you</p>