title: VBA: Considering only the value of the last cell in A and extend selection untill W
body: <p>I have several columns from A  to W. some aer full and some empty and some with "0", but i need to get the last value in A and  selecting from A17 untill W (LastValueOfA)</p>
  
  <p>For example A is starting from rows 17,  B arrive untill 30 and W is full of 0 till the end of the sheet. I want a selection from A17 till W that stops where there is the last value of A and then copy or cut the values and append them on another sheet of the same file called "order inputs".</p>
  
  <p>At the moment i only found the way to found and select the lastrow with values inside, but it consider all the columns obviously, not only A:</p>
  
  <pre><code>Dim wb As Workbook
  
  LASTROW = Sheet1.Range("A" &amp; Rows.Count).End(xlUp).Row
  Range("a17:W" &amp; LASTROW).Select
  </code></pre>
  
  <p>Thanks in advance.</p>