title: Excel tab sheet names vs. Visual Basic sheet names
body: <p>It seems that Visual Basic can not reference sheets according to user-modified sheet names. The worksheet tabs can have their names changed, but it seems that Visual Basic still thinks of the worksheet names as Sheet1, etc., despite the workbook tab having been changed to something useful.</p>
  <p>I have this:</p>
  <pre><code>TABname = rng.Worksheet.Name  ' Excel sheet TAB name, not VSB Sheetx name.
  </code></pre>
  <p>but I would like to use sheet names in Visual Basic routines. The best I could come up so far is to Select Case the Worksheet Tab vs. Visual Basic names, which doesn't make my day.</p>
  <p>Visual Basic must know the Sheet1, Sheet2, etc., names. How can I get these associated with the Excel tab names so that I don't have to maintain a look-up table which changes with each new sheet or sheet tab re-naming?</p>