Thread: Help with Macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] imageswords.br@gmail.com is offline
external usenet poster
 
Posts: 14
Default Help with Macro

Hi,
change this ...Cells(X, "T") < "N".... to ...UCase(.Cells(X, "T")) <
"N" ...
this will convert .Cells(X, "T") 's value to upper case before
conducting the test < "N". So it will always be comparing an upper
case value to the (upper case) "N".
The complimentary function is LCase() which converts a string to its
lower case version.
Hope this helps.
Regards
Bernie