View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default Sorting Names in an Array


"SuperPhil" <tradingtools.free.fr wrote in message
...
Folks,
I have to more clear:

I exported one spreadsheet into a 2 dimensions array for speed reason.
I would like to sort lines by code names, and not sort letters into
these names.

For example:

Jaguar,10
Ferrari,20
Mercedes,30
Februray, 40
Fest,50

The result should be:
Februray, 40
Ferrari,20
Fest,50
Jaguar,10
Mercedes,30



Then I'd definitely suggest you use a disconnected ADO recordset
see

http://support.microsoft.com:80/supp...NoWebContent=1

Keith