Binary sorting?

[Roderick]

Hello!

In VBA I can set an option compare to binary in order to compare
strings
case sensitive. With that option set, "a" and "A" are treated as
different
values ("A" < "a")
But if I use the sort method with MatchCase:=True the sort order is "a"
<
"A" !

What I need is compare mode and sort mode to behave according to the
same
order of characters/strings.

Is there a way around this? Can I sort binary? Or am I missing
something else?

Any help is appreciated

Herbert Becker

 

[Tom Ogilvy]

Not with the built in sort function. You would have to write your own.