title: Create Items through splitting a string by comma(,) and add them to the collection
body: <p>I have a collection called as <code>SheetNameCollection</code> and I have a string called as SheetNames.</p>
  
  <p>Here goes my code,</p>
  
  <pre><code>Dim SheetNames As String
  Dim SheetNameCollection As Collection
  Set SheetNameCollection = New Collection
  SheetNames = "wk1,wk2,wk3,wk4"
  'This is dynamic and will usually be more than 100 sheets.
  </code></pre>
  
  <p>I am looking for a way to add these SheetNames one by one into my collection SheetNameCollection.</p>
  
  <p>Kindly suggest an approach. Thanks.</p>