Excel - Binary和Text两种Compare方法

Option Compare statement

VBA里可以定义默认使用的compare方法：

' Set the string comparison method to Binary.

Option Compare Binary ' That is, "AAA" is less than "aaa".

' Set the string comparison method to Text.

Option Compare Text ' That is, "AAA" is equal to "aaa".

This example uses the Option Compare statement to set the default string comparison method. The Option Compare statement is used at the module level only.

If used, the Option Compare sta