title: Dumping variant array to range - VBA excel error 1004
body: <p>I'm using <a href="/questions/tagged/vba" class="post-tag" title="show questions tagged &#39;vba&#39;" rel="tag">vba</a> for Excel in order to save data into an array by:</p>
  
  <pre><code>Dim allPosts As Variant
  allPosts = Range("A2:J5000")
  </code></pre>
  
  <p>after that I'm changing data in the <code>allPosts</code> array, and then I want to paste it back by:</p>
  
  <pre><code>Range("A2:J5000").Value = allPosts
  </code></pre>
  
  <p>I'm getting the error:</p>
  
  <blockquote>
    <p>run time error 1004 Application-defined or object-defined</p>
  </blockquote>
  
  <p>and the copy stops at a specific cell, when i <strong>change the string at this cell to be shorter</strong> the problem is solved.</p>
  
  <p>thanks</p>