title: Copy/Paste variable dataset between workbooks without clipboard
body: <p>I've been trying to optimize some of my coding and managed to cut and speed it up a lot. However there are some things that are still quite clunky (and me still a noob). Backstory is that my code is opening source and target files, copies a lot of data of variable length, closes source and then does a lot of operations and finally saves target file. </p>
  
  <p>One of the things Id like is to do if possible is a direct copy of data without using clipboard, activating workbooks, selecting sheets (whatever of this is possible to pack into more efficient code that I am currently having)</p>
  
  <pre><code>Windows("SOURCE.xlsm").Activate
  Sheets("Data").Select
  Range("A2:AX10").Select
  Range(Selection, Selection.End(xlDown)).Select
  Selection.Copy
  Windows("TARGET.xlsm").Activate
  Range("A2").Select
  ActiveSheet.Paste
  Application.CutCopyMode = False
  </code></pre>
  
  <p>Is it possible to do a selection (A2:AX10 and all the way down to last row) in SOURCE file-Data sheet and directly copy it to TARGET file-Data sheet cell A2 without using clipboard. </p>
  
  <p>The reason why I use A2:AX10 and then selection down is because I have a lot of blank cells in the whole data set and this way I get entire data. </p>
  
  <p>I would like to be able to to that selection and use it as a range in this line</p>
  
  <pre><code>Workbooks(“SOURCE”).Worksheets("Data").Range(“A2:AX10 &amp; ALLTHEWAYDOWN”).Copy _Workbooks(“TARGET”).Worksheets("Data").Range(“A2")
  </code></pre>
  
  <p>I was trying to solve this but I dont end up with desired result. When I try doing selection and setting as range then both trying copy range with activitng workbooks and in the direct copy mode I get 1004 error.   </p>
  
  <p>Is it possible to optimize this chunk and make it work. It would improve a lot of my VBA. </p>
  
  <p>Thanks, </p>