Macro_AND function

[Aline]

There is an formula I’d like to add it in a macro.
=IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N")

I want it to automatically fill up for the rest of row.

Any suggestion?

Thanks,

 

[Aline]

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,