| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement in macro
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro if and / or statement | Excel Discussion (Misc queries) | |||
| If Statement to run a macro | Excel Discussion (Misc queries) | |||
| If statement in macro | Excel Discussion (Misc queries) | |||
| can i use an IF Statement to run a macro? | Excel Worksheet Functions | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
