title: Array and Split commands to create a 2 dimensional array
body: <p>I'm having some trouble populating an array using a split command.</p>
  
  <p>The string I currently have is below</p>
  
  <pre><code>MyString = "Row1 Column1[~]Row1 Column2[~]Row1 Column3" &amp; vbNewLine &amp; _
  "Row2 Column1[~]Row2 Column2[~]Row2 Column3" &amp; vbNewLine &amp; _
  "Row3 Column1[~]Row3 Column2[~]Row3 Column3" &amp; vbNewLine &amp; _
  "Row4 Column1[~]Row4 Column2[~]Row4 Column3"
  </code></pre>
  
  <p>I have an array that I want to be multi-dimensional and would like each Row# Column# to be in the correct part of the array based on its number.</p>
  
  <p>For example</p>
  
  <pre><code>MyArray(1,1) = "Row1 Column1"
  MyArray(2,1) = "Row2 Column1"
  MyArray(3,1) = "Row3 Column1"
  MyArray(4,1) = "Row4 Column1"
  
  MyArray(1,2) = "Row1 Column2"
  MyArray(2,2) = "Row2 Column2"
  MyArray(3,2) = "Row3 Column2"
  MyArray(4,2) = "Row4 Column2"
  
  MyArray(1,3) = "Row1 Column3"
  MyArray(2,3) = "Row2 Column3"
  MyArray(3,3) = "Row3 Column3"
  MyArray(4,3) = "Row4 Column3"
  </code></pre>
  
  <p>Now I understand how to populate a single dimension array using the split command</p>
  
  <pre><code>MyArray = Split(MyString, vbNewLine)
  </code></pre>
  
  <p>This would mean that</p>
  
  <pre><code>MyArray(1) = "Row1 Column1[~]Row1 Column2[~]Row1 Column3"
  MyArray(2) = "Row2 Column1[~]Row2 Column2[~]Row2 Column3"
  MyArray(3) = "Row3 Column1[~]Row3 Column2[~]Row3 Column3"
  MyArray(4) = "Row4 Column1[~]Row4 Column2[~]Row4 Column3"
  </code></pre>
  
  <p>But I don't know how to use a split command to populate the second dimension.</p>
  
  <p>Is this possible and if it is how?<br>
  If it isn't possible, can anyone suggest how to actually populate this?</p>