View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AD108 AD108 is offline
external usenet poster
 
Posts: 21
Default Going nuts on this one...

I can't figure out why the following expression is evaluating to True when
UCase(z(i, 1)) is equal to ""
What am I missing here. Thanks in advance for any help.

If UCase(z(i, 1)) < "CS" And UCase(z(i, 1)) < "" And UCase(.Cells(intPos,
8)) = "CS" Or UCase(.Cells(intPos, 8)) = "" Then