Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi:
I am having difficulty writing a macro with the if and /or together. Column C will be = "GOOD" if B is different than "VOY" and A is iqual to London and Cambridge. A B C London VOY Cambridege GOOD London GOOD I have the below string but it is just evaluating the second part of the string Do (the and conditions) If ActiveCell.Offset(0, -1) < "VOY" And ActiveCell.Offset(0, -2) = " London" Or ActiveCell.Offset(0, -2) = "Cambridge" Then ActiveCell.Value = "GOOD" ActiveCell.Offset(1, 0).Select Else ActiveCell.Offset(1, 0).Select End If Loop Until ActiveCell.Offset(0, -13) = "" Could anyone help me please. Thanks, Orquidea |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statement in 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 | |||
If statement in a Macro | Excel Discussion (Misc queries) | |||
if statement in Macro | Excel Worksheet Functions |