Check String Case


Hi All, You can use this function to check the case of a string. Function CheckCase(rngDta as Range) As┬áByte ‘======================================================== ‘How this Works ‘Pass a string argument to check the case of string ‘it would Return 1 in case of UpperCase ‘it would Return 2 in case of ProperCase ‘it would return 3 in case…