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