title: Copy and Pasting Columns through Arrays
body: <p>Copy and pasting the columns <code>A2:A</code> and <code>B2:A</code> from <code>Sheet1</code> to <code>Sheet6</code> and my code is working fine.</p>
  <p>when code paste the data it starts pasting form <code>A1</code> and <code>B1</code> i want to paste the data form <code>A2</code> and <code>B2</code> in Sheet6.</p>
  <pre><code>Dim ColumnAarray() As Variant
  Dim my_Arange As Range
  LastRow = Sheet1.Cells(Sheet1.Rows.Count, &quot;A&quot;).End(xlUp).Row
  Set my_Arange = Sheet1.Range(&quot;A2:B&quot; &amp; LastRow)
  ReDim ColumnAarray(LastRow)
  ColumnAarray = my_Arange
  For i = LBound(ColumnAarray) To UBound(ColumnAarray)
      Sheet6.Range(&quot;A&quot; &amp; i) = ColumnAarray(i, 1)
      Sheet6.Range(&quot;B&quot; &amp; i) = ColumnAarray(i, 2)
  Next i
  </code></pre>
  <p>I just want to paste the data from row2.</p>