title: VBA Copy alternating columns to adjacent columns
body: <p>So I want to copy column DC and DE from one file to column N and O from another file. With the code I have now it copies the value from column DC in both column N and O. I checked and the correct columns are selected with <code>Range("DC2:DC" &amp; numRows &amp; "," &amp; "DE2:DE" &amp; numRows)</code>.</p>
  
  <pre><code>Set wbCSV = Workbooks.Open(Filename:=Worksheets("Sheet1").TextBox1.Value)
  
  'Copy data
  With wbCSV
   numRows = Cells(Rows.Count, "A").End(xlUp).Row
   LTOE = .Sheets(1).Range("DC2:DC" &amp; numRows &amp; "," &amp; "DE2:DE" &amp; numRows).Value
   .Close
  End With
  
  'Paste data
  Worksheets("Sheet1").Range("N18:O" &amp; numRows + 16).Value = LTOE
  </code></pre>