title: Copy range of cells from one sheet to another
body: <p>I want to copy a column with a varying number of entries (by using .End(xlDown)) into column C of another sheet going downwards.</p>
  
  <pre><code>With Sheets("General Text")
      Range(Range("A2"), Range("A2").End(xlDown)).Copy 
      Destination:=Sheets("Compiler").Range(Range("C2"), Range("C2").End(xlDown))
  End With
  </code></pre>
  
  <p>I'm not sure if this is the easiest method, but I've tried a few iterations and it always errors</p>