LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Sort a range of strings using VBA code?

IMO, sorting the list in the worksheet via the Sort method of the Range
object is the fastest way. Any sort algorithm implemented in VB[A] is
*always* going to be slower than Excel's built-in Sort feature!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quick method to sort a list of strings? ker_01 Excel Programming 2 October 20th 08 05:21 PM
Use Formula to sort two strings Ray Ray Excel Worksheet Functions 2 January 15th 08 12:37 PM
macro code to sort a range ashish128 Excel Discussion (Misc queries) 5 August 17th 06 05:52 PM
Sort a row of strings, some containing blanks KobusD Excel Programming 8 September 2nd 05 08:39 PM
Replacing VBA code strings by using VBA code? shoba[_2_] Excel Programming 1 June 27th 05 10:42 PM


All times are GMT +1. The time now is 06:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"