title: Using XlDown and select a defined column range
body: <p>I have this code that is using xlDown to determine the last row of data (minus 1) but I need to go to a defined column. So the selection would be as follows:
  Go to A6 then do an xlDown -1
  Then select the resulting row from xlDown and combine it with column BU</p>
  
  <p>As an example, if the result from the xlDown is row 89 then the range to select should be <code>A6:BU89</code>
  I tried using the <code>xlRight</code> but the data is inconsistent and can have blank columns in different places but I always want to go to column BU.</p>
  
  <p>I can't seem to get it right, can someone help me out?</p>
  
  <pre><code>Sub AAPrepare_Pipeline_Data()
    Range("A6").Select
    Range(Selection, Selection.End(xlDown).Offset(-1)).Select
    'Range(Selection, Selection.End(xlToRight)).Select
    Selection.Copy
  End Sub
  </code></pre>