title: How do I write from a Multi-Dimensional Array?
body: <p>I have a multi-dimensional array that is filled using a single line of Code:</p>
  
  <blockquote>
    <p>ArrayName = Worksheets("SourceDataWorkSheet).Range("A18:BM174")</p>
  </blockquote>
  
  <p>The advantage of filling the array using this method, rather than a cell-by-cell loop count, is that it fills in less than a second - even for such a large data array. </p>
  
  <p><strong>Is it possible to write the data out just as quickly?</strong></p>
  
  <p>At the moment I am writing the data out (after finding the appropriate place to paste) cell by cell through a loop arrangement, and it's really slowing the whole process down. </p>
  
  <p>What I aim to do is to be able to paste the second dimension of the array in a Column in the worksheet DestinationSheet (after there has been a loop to determine where to put it). In other words, once the destination row for Array (1, x) has been found, I want to paste the values of X into the Range(H20:AB20) (for example), but I can't work out how to paste without using the looping cell values. </p>