Transformer
07-12-2013, 12:55 PM
UsefulGyaan Has Posted the Following On 07-12-2013 01:23 PM:
If we compare text in VBA Code then “B” is not equal to “b” since there ASCI code’s are totally different. However we can force Excel code to compare text on the basis of* Text not on their Binary values. Make use of *Option Compare Text on the very First line of the Code module. […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=1209&subd=usefulgyaan&ref=&feed=1
Text Comparison (http://usefulgyaan.wordpress.com/2013/07/12/text-comparison/)
If we compare text in VBA Code then “B” is not equal to “b” since there ASCI code’s are totally different. However we can force Excel code to compare text on the basis of* Text not on their Binary values. Make use of *Option Compare Text on the very First line of the Code module. […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=1209&subd=usefulgyaan&ref=&feed=1
Text Comparison (http://usefulgyaan.wordpress.com/2013/07/12/text-comparison/)