title: Sort by Ascending Order in vba with Variable Last Row
body: <p>I am having a hard time analyzing the problem in my code. I need to sort ColumnE by ascending order but the problem is the rows that should not be included in the sorting was also sorted.</p>
  
  <p><a href="https://i.stack.imgur.com/8YC9U.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8YC9U.jpg" alt="enter image description here"></a></p>
  
  <p>The highlighted in yellow should not be included in the sorting process. I need to start the sorting in row3.</p>
  
  <p>Here is my code: </p>
  
  <pre><code>        'sort by ascending order
          wsRD.Columns("C:E").Sort key1:=wsRD.Range("E1"), _
          order1:=xlAscending, Header:=xlYes
  </code></pre>
  
  <p>Can anyone tell me what's wrong in  my code? Appreciate your help. </p>
  
  <p>Thank you.</p>