title: Sorting Range Left to Right from Row 2
body: <p>I have 3 rows in excel with numbers that I want to sort left to right from smallest to largest values of Row 2 in VBA.</p>
  
  <p><b> I found how to do it based on first row: </b></p>
  
  <pre><code>Range(Rows(1),Rows(3)).Sort Key1:=Range(Rows(1),Rows(3)), Order1:=xlAscending, Orientation:=xlLeftToRight
  </code></pre>
  
  <p><b> This is what I have: </b>
  <br> 5,6,2,1
  <br>4,3,2,1
  <br>a,d,w,x</p>
  
  <p><b> This is what I want: </b>
  <br> 1,2,6,5
  <br> 1,2,3,4
  <br> x,w,d,a</p>
  
  <p>any ideas what little line of code i need to add to what I have that will make it work?</p>