search for lowercase letter in two-letter 'word'
If I understand your request properly :
Find the ones you need like this
If cells(nRow,nCol).value < UCase(cells(nRow,nCol).value) then
' Your code in here
endif
This will find occurences of lower case characters in your cell values.
--
If the post is helpful, please consider donating something to an animal
charity on my behalf .......... and click Yes
"ppeer" wrote:
Hi There,
If I find a second character lowercase letter in a word, I have to
identify the cell Offset(-1,1).
The words are like: Mc, Mv, Np and are all positioned in column C.
Also there, we find words like MK,LP,ET.
haven't found a solution yet,
Regards
.
|