title: Parsing 2D delimited string into a range
body: <p>I have a two dimensional string delimited by line and within each line delimited by value.</p>
  
  <p>So it's a comma delimited string with an EOL marker at the end of each line. Example:</p>
  
  <pre><code>val1, val2, val3 ... valn [EOL]
  val1, val2, val3 ... valn [EOL]
  ...
  val1, val2, val3 ... valn [EOL]
  </code></pre>
  
  <p>If I create a loop to split() each line by [EOL] then another loop inside that to split() each value by ',' and then write each value one at a time to a cell in the worksheet it takes forever so I'm looking for a more efficient solution.</p>
  
  <p>Is it possible to parse the string into a 2D array/variant and then write the whole thing at once to a named range?</p>