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.
|