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
|