title: Getting sheet indice from Sheet Name in VBA
body: <p>I need to pull a sheet's position in a workbook knowing only it's name -- so for instance:</p>
  
  <p>if we have a sheet, say<br>
  <code>Workbook.Sheets("Sheet2")</code>  </p>
  
  <p>how would I find the corresponding integer so that I could refer to it as:
  say i is an integer<br>
  <code>Workbook.Sheets(i)</code></p>
  
  <p>I need to be able to do this reverse indicing so I can refer to sheets next to the sheet I'm referencing.</p>
  
  <p>Thank you for your help.</p>