Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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, Austria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Binary NOT? | Excel Worksheet Functions | |||
binary format | Excel Discussion (Misc queries) | |||
Hexadecimal to binary | Excel Discussion (Misc queries) | |||
Solver returns non binary answer in binary constrained cells | Excel Worksheet Functions | |||
Binary operations (left/right shift, binary and/or, etc.) | Excel Programming |