title: Last column sorting for multiple fixed rows through VBA
body: <p>trying to fix the macro for sorting on the last column of every sheet but the rows are fixed A3:A20 &amp; A23:A32. Found the below code but I am unable to lock rows in it.
  unable to crack how to define the rows in the below code.
  <a href="https://i.stack.imgur.com/5DRTb.png" rel="nofollow noreferrer">sample data</a></p>
  <pre><code>Sub jusho()    
      Dim lColumn As Long
      lColumn = Cells(1, Columns.Count).End(xlToLeft).Column
      LastRow = Range(&quot;A&quot; &amp; Rows.Count).End(xlUp).Row
      
      Range(Cells(2, 1), Cells(LastRow, lColumn)).Sort key1:=Range(Cells(2, lColumn), Cells(LastRow, lColumn)), _
         order1:=xlAscending, Header:=xlNo
  End Sub
  </code></pre>