Excel Sorting Problem

E

Eric Weller

This one has me stumped.

I have a VB Script that is as follows:
if "~~~" <"~A~" then
msgbox("~~~ comes before ~A~")
else
msgbox("~A~ comes before ~~~")
end if

When I execute the script it returns "~A~ comes before ~~~". This is correct.

But when I put "~~~" and "~A~" in an Excel spreadsheet and sort them, it
lists as follows:
~~~
~A~

I have verified my sorting options in data > sort > sort options.

Why is VB Script sorting one way and Excel sorting another?
Thanks in advance!!
 
D

Dave Peterson

I'm not sure anyone here can definitively answer a "why" question.

Except for "that's the way the developers did it".

You may want to look at: "Default sort orders" in excel's help.
 
Top