title: Sort data in Excel using the 'Auto Filter' using VB.net?
body: <p>I have AutoFilter in place in my sheet. I want to sort data using the AutoFilter itself and not by normal sort.</p>
  
  <p>I want the client to see the down arrow on the autofilter button, which tells that rows are sorted on this key.</p>
  
  <p>Any idea how to do that ?</p>
  
  <p>I have 'sheet' as an object :</p>
  
  <pre><code>  sheet.Range("A2").AutoFilter then ??
    Or something else ??
  </code></pre>
  
  <p>Please help !</p>
  
  <p>(Ensure the syntax for VB.Net and not VB Script)</p>
  
  <p>I am a newbie.. </p>