title: Copy data up to last used column with vba
body: <p>I was successfully able to copy data up to the last used row using VBA. I am trying to do the same thing but copy data from A1 to LastColumn2. Here is the code I have put together thus far:</p>
  <pre><code>Sheets(&quot;Results&quot;).Select
  LastColumn = Cells(1, Columns.Count).End(xlToLeft).Column
  Range(&quot;A1:&quot; &amp; LastColumn &amp; &quot;2&quot;).Select
  Selection.Copy
  </code></pre>
  <p>The debugger highlights the third line. This is just a portion of the code - All of the variables have been dimensioned properly.</p>