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.

--
Regards,
Tom Ogilvy


"Roderick" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Roderick
> ------------------------------------------------------------------------
> Roderick's Profile:
http://www.excelforum.com/member.php...o&userid=13981
> View this thread: http://www.excelforum.com/showthread...hreadid=483489
>