title: vbNewline vs Chr(10) as linebreak delimiter in Windows vs. Mac OSX
body: <p>I have an Excel sub that uses the <code>Split()</code> function to split CSV data from a cell into an array. However, depending on the version of Excel/OS I'm using, the character used as the line break delimiter changes:</p>
  
  <p>Excel 2011 / Mac OSX:</p>
  
  <pre><code> fullArray = Split(CSV, vbNewLine) 'successfully returns array
  
   fullArray = Split(CSV, Chr(10)) 'fails and returns only a single cell
  </code></pre>
  
  <p>Excel 2007 / Windows 7:</p>
  
  <pre><code>  fullArray = Split(CSV, Chr(10)) 'successfully returns array
  
    fullArray = Split(CSV, vbNewLine) 'fails and returns only a single cell
  </code></pre>
  
  <p>Anyone else noticed this/has an explanation why this is going on?</p>