vba: how to detect if current character letter or number
- by I__
i would like to be able to check whether a character is a letter (including caps and lcase) or a number. something like:
ascii(mid(some_String,1,1)) > 10 and ascii(mid(some_String,1,1)) < 40
or
ascii(mid(some_String,1,1)) > 100 and ascii(mid(some_String,1,1)) < 200
how do i do this?