title: Column selection to lastrow then resize
body: <p>I have a code that finds the last row of data in column E and selects the column to that last row. I want to be able to select associated data in columns B through D that goes with column E and then sort based on column B. So I thought I would just find the last row in column E then resize by 3 columns and sort from that selection but I keep getting a run-time error 1004 application-defined or object-defined error. I have provided the code I'm using below. Columns B through D contain data past the end of column E. Thanks!</p>
  
  <pre><code>ws.Range("E1:E" &amp; finalrow).Resize(0, 3).Select
  </code></pre>