Sort Array

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: dsc (dsc_at_gol.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 21:27:52 +0900

I have an array of three columns and a variable number of entries.

Is there some way in VBA to sort this array according to the length of the
string in the first field?

Any assistance gratefully received.

dsc
Yokohama

Relevant Pages

  • Re: String handling
    ... The quick and dirty way to sort in VBA is to use a hidden form with a ... Set the ListBox's Sorted property to true. ... array index values -- into the ItemDataproperty. ... and you can sort on the column. ...
    (microsoft.public.word.vba.beginners)
  • Re: Removing duplicates testing in 2 coloms
    ... If a name has more then one entries it is not displayed at all. ... result as the Advanced Filter/Unique Records only. ... Yes, of course you can do this in VBA, either by coding the steps I described ... array, concatenating the first and last names into a 2nd array, then comparing ...
    (microsoft.public.excel.programming)
  • Re: Sorting objects in ooRex? is this possible with data structures?
    ... Currently the only sort available in ooRexx is SysStemSort and it ... In ooRexx 3.2 there are several new sort methods coming. ... the quickSort the sequence of array entries with the same key value may change (the result is still ... The sort methods are defined for the Array class. ...
    (comp.lang.rexx)
  • Re: how to find union of two arrays
    ... If regularly trying to find individual items in a large sorted array, search "binary chop", which will find matches in negligible time even in large arrays. ... Indeed, reading cells is considerably longer than reading array values, though there will be some overhead initially reading 2x50k cells to a array or pair of arrays. ... It really is important to sort the first array, whether using built-in Excel functions or VBA. ...
    (microsoft.public.excel.programming)
  • Re: sort an array on selected column
    ... spreadsheet. ... then goto Data> Sort> Sort By (select the column ... >I want to sort an array using VBA independently of the spreadsheet. ...
    (microsoft.public.excel.programming)