title: I get problems creating a collection in Excel VBA
body: <p>In the VBA Editor, I have created a new collection of worksheets with the following code:</p>
  
  <pre><code>Set Page1s = New Collection
  Page1s.Add Workbook010.Sheets("1stPage")
  </code></pre>
  
  <p>For now, I've got only one worksheet in this collection that I'd like to copy with the following code</p>
  
  <pre><code>Workbook010.Page1s(1).Copy After:=Sheets("1stPage")
  </code></pre>
  
  <p>The here above line of code generate a Run-Time Error 9, Subscript out of Range...
  I don't understand why can't I reach the first item of the collection that I have just created?
  I thank you very much in advance for your feedback.
  Franz </p>