title: Error 13 - Type mismatch adding 2 columns together
body: <p>I'm guessing I can't get away with this?</p>
  
  <pre><code>Workbooks(ms).Sheets(fm).Range("H1:H50000").Value = Workbooks(ss).Sheets(cl).Range("I1:I50000").Value + Workbooks(ss).Sheets(cl).Range("J1:J50000").Value
  </code></pre>
  
  <p>Trying to get the new column to be the sum of the values in the other two. Why won't it let me? </p>
  
  <p>Also, the below works just fine. It's just when I try adding 2 columns:</p>
  
  <pre><code>Workbooks(ms).Sheets(fm).Range("A1:A50000").Value = Workbooks(ss).Sheets(cl).Range("M1:M50000").Value
  </code></pre>