Hi Tom,

Do you know can I modify it so it will automatically run the formula for the
rest of rows in the macro? Similar to another formula I've already had:
..Range("L3:L" & LastRow).Formula _
= "=IF(E3=""B"", ""Y"", IF(OR(E3=""C""," _
& "E3=""E""), ""Y"", ""N""))"

Thanks,
Aline



--
Aline


"Tom Hutchins" wrote:

Try something like

ActiveCell.Formula = "=IF(AND(L3=""Y"", M3=""Y"", N3=""Y""), ""Y"", ""N"")"

Hope this helps,

Hutch

"Aline" wrote:

This is the formual:
=IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N")

I am having a hard time to add it in my existing macro.


********
FYI, I have an OR formula in my macron that works very well:
=IF(OR(E3="B", E3="C", E3="E"), "Y", "N")

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

Any suggestion?

Thanks,


--
Aline

--
Aline