Another formula (OR formula) I have: =IF(OR(E3="B", E3="C", E3="E"), "Y", "N")

It works well in the macro:

..Range("L3:L" & LastRow).Formula _
= "=IF(E3=""B"", ""Y"", IF(OR(E3=""C""," _
& "E3=""E""), ""Y"", ""N""))"

Just could not figure out what to do with AND formula.

Thanks,


--
Aline