title: Can we sort an Excel worksheet based on one column?
body: <p>I have an Excel worksheet and would like for all its values to be sorted in an alphabetical order.  By instance, let's say I have:</p>
  
  <pre><code>Col 1 | Col 2
  ------+-------
     z  |   26
  ------+-------
     a  |   1
  ------+-------
  </code></pre>
  
  <p>I would like to have</p>
  
  <pre><code>Col 1 | Col 2
  ------+-------
     a  |   1
  ------+-------
     z  |   26
  ------+-------
  </code></pre>
  
  <p>and not</p>
  
  <pre><code>Col 1 | Col 2
  ------+-------
     a  |   26
  ------+-------
     z  |   1
  ------+-------
  </code></pre>
  
  <p>I know I can sort the first column using</p>
  
  <pre><code>Target.EntireColumn.Sort Key1:=Target, Order1:=xlAscending, Header:=xlGuess,
  OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
  </code></pre>
  
  <p>But sorting the first column like this produces the result I don't want.</p>
  
  <p>Anyone has any ideas?</p>