title: Copy multiple ranges with VBA
body: <p>I am trying to copy multiple ranges using Excel VBA. I understand that in order to select multiple ranges, syntax similar to that below is used:</p>
  
  <pre><code>Range("A1:B4000, F1:F4000").Select
  </code></pre>
  
  <p>This works fine in <em>selecting</em> the appropriate range. However, the following:</p>
  
  <pre><code>Range("A1:B4000, F1:F4000").Copy
  </code></pre>
  
  <p>...only copies the A1:B4000 range. This is the first problem I am facing.</p>
  
  <p>Secondly, I would like to dynamically copy the data to the bottom row, which is not necessarily row #4000. If selecting a single range, the syntax is as follows:</p>
  
  <pre><code>Range("A1", Range("B1").End(xlDown)).Copy
  </code></pre>
  
  <p>The above code successfully copies everything from A1 to the bottom of the B column. I can't find any material on the net explaining how to do this for multiple selections.</p>
  
  <p>What I'm essentially trying to do is copy A1:B(bottom) and F1:F(bottom), but the above two issues are stopping me. I assume this is a syntax issue..?</p>