title: Excel VBA: xlToRight then offset, then xlDown and offset again?
body: <p>I am trying to do the following:</p>
  
  <ul>
  <li>Select cell B3</li>
  <li>Select the furthest right value, then offset that two columns to the right</li>
  <li>Copy the value in that cell, then paste it to below the bottom value of the column the cell sits in.</li>
  </ul>
  
  <p>I am trying to do it as follows:</p>
  
  <pre><code>Range("B3").Select
  'Select value 2 columns to the right of the last value in the row
  Selection.End(xlToRight).Offset(, 2).Select
  Selection.Copy
  'Do the same again, this time paste that copied value at the bottom of the column that cell is in
  Range("B3").Select
  Selection.End(xlToRight).Offset(, 2).Select
  Selection.End(xlDown).Offset(1).Select
  ActiveSheet.Paste
  </code></pre>
  
  <p>However, there is an issue with the code on the line:</p>
  
  <pre><code>Selection.End(xlDown).Offset(1).Select
  </code></pre>
  
  <p>Which gives the error:</p>
  
  <blockquote>
    <p>Run-time error '1004': Application-defined or object-define error</p>
  </blockquote>
  
  <p>I am not sure how I can instruct VBA to select not just the cell below the cell that is 2 columns to the right from the end of the row, but the last value in the column that cell sits in.</p>