View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ROCKnRLR[_4_] ROCKnRLR[_4_] is offline
external usenet poster
 
Posts: 1
Default Sorting of text data different in Excel adn VBA? Office 2K3

NickHK wrote:
*ROCKnRLR,
If you put an "Option Compare Binary" at the top of the form/module
you get
False, "Option Compare Text" returns True.
VBA defaults to Binary, whereas Excel is Text.
* [/color]

THANKS!!

--
Message posted from http://www.ExcelForum.com