title: Excel VBA Quickest way to sort an array of numbers in descending order?
body: <p>What is the quickest way (in terms of computational time) to sort an array of numbers (1000-10000 numbers but could vary) in descending order? As far as I know the Excel build-in functions is not really efficient and in-memory sorting should be a lot faster than the Excel functions.</p>
  
  <p>Note that I can not create anything on the spreadsheet, everything has to be stored and sorted in memory only.</p>