AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() If used, the Option Compare statement must appear in a module before any procedures. You should be able to avoid this issue by making your search case-insensitive by changing MatchCase := True.Īlso see this information about the EXACT function for comparing strings.Īnother option is to declare your sensitivity at the module level, with the Option Compare statement: In the case of your character: d = D = ᵈ = ⅆĪ more common example (where I live, anyway) would be E = e = É = é. While the English Alphabet may only have pairs of matching characters (ie, D vs d), characters exist that may be considered equivalent in other languages for characters sets. ![]() Excel's trying to help you out by being case-insensitive.
0 Comments
Read More
Leave a Reply. |