title: Excel 2010 VBA: How to store an array of worksheets as a variable?
body: <p>I am trying to have several arrays of my worksheets that I can call up in my code using.</p>
  
  <pre><code>ThisWorkbook.Sheets(Array("Sheet1", "Sheet3"))
  ThisWorkbook.Sheets(Array("Sheet2", "Sheet5"))
  </code></pre>
  
  <p>I am wondering if there is anyway to set up a variable similar to the following:</p>
  
  <pre><code>Dim ArrayOne As String
  Dim ArrayTwo As String
  
  ArrayOne = ThisWorkbook.Sheets(Array("Sheet1", "Sheet3"))
  ArrayTwo = ThisWorkbook.Sheets(Array("Sheet2", "Sheet5"))
  
  ArrayOne 'Call this Array then save
  
  Filename:="C:\Data\testfile.xls", FileFormat:= _
  xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _,
  CreateBackup:=False 
  
  ArrayTwo 'Call this array then save
  
  Filename:="C:\Data\testfile.xls", FileFormat:= _
  xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _,
  CreateBackup:=False 
  </code></pre>
  
  <p>Please let me know if you can help me!!</p>