View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default 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
.