View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Fast string comparison (and sort)

"Claus Busch" wrote:

why do you want to compare the strings? Do you want to sort them?
If so and you have stored your strings in varOut (1D Array) then try:


Actually, I am experimenting with an "insert sort". I want to insert
words, one at a time, into column A of my spreadsheet.
If I need to insert a word between two words, I am using the
Selection.Insert command to make a new row for the new word.

Do you have any suggestions on how to achieve this sort in
ascending order? For now I'm trying to perform an "insert sort",
and column A will store all words after the sort is complete.