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

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

--
Regards,
Tom Ogilvy


"Roderick" wrote in
message ...

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