title: How can I create a vector in VBA?
body: <p>I have a small issue where I need to create a vector in <code>EXCEL VBA</code>.</p>
  
  <p>I have the following scenario</p>
  
  <pre><code>str=Sheets("Indata").Range("$C$12")
  
  Vector= str
  </code></pre>
  
  <p>For example if the cell in <code>C12</code> is 11 I want the following output:</p>
  
  <pre><code>Vector= "1 2 3 4 5 6 7 8 9 10 11"
  </code></pre>