title: VBA Excel - Assigning multiple values to an array using a single variable
body: <p>For my issue i have checked the archive and there is a similar thread but my issue is slightly different and i cant seem to be able to tweak my code to make it work.
  The similar one is here: <a href="https://stackoverflow.com/questions/17169208/excel-2010-vba-how-to-store-an-array-of-worksheets-as-a-variable">Excel 2010 VBA: How to store an array of worksheets as a variable?</a></p>
  
  <p>I am trying to assign a series of tabs to an array using a variable. The variable uses a value in a cell on another sheet.</p>
  
  <pre><code>Dim VendorTabsArray As Variant
  
  VendorTabs= Sheets("OtherSheet").Range("A1").Value
  VendorTabsArray = Array(VendorTabs)
  
  ActiveWorkbook.Sheets(VendorTabsArray).Select
  </code></pre>
  
  <p>The actual value in the cell A1 i wish to use as variable to put into the tab array is <strong>"EBS - Add User", "EBS - Modify User", "EBS - Delete User", "EBS - Re-Enable User", "EBS - Password Reset", "EBS - Access Profiles Roles", "EBS - Reporting"</strong></p>
  
  <p>This give me a Subscript out of range error.</p>
  
  <p>When i add a watch to VendorTabArray, it does not seem to recognize the quotes and commas in the variable and just adds the whole list of tabs into the first array position instead of splitting them out.</p>
  
  <p>Does any know how i can select these tabs using an array from a variable whereby the variable is a cell reference that contains all required tabs?</p>
  
  <p>Any help is very much appreciated as it has me baffled.</p>