If Cell.Value = "I&S" Then Cell.Offset(0, 1).Value = "No" And Cell.Offset(0, 2).Value = "Yes"
The first part of the above code works fine - if the cell being evaluated is "I&S" then the cell to the right populates with "No". This works because I ran it separately. But when I add the second part
And Cell.Offset(0, 2).Value = "Yes"
I get an error message.
What am i missing here?
Thanks!
The first part of the above code works fine - if the cell being evaluated is "I&S" then the cell to the right populates with "No". This works because I ran it separately. But when I add the second part
And Cell.Offset(0, 2).Value = "Yes"
I get an error message.
What am i missing here?
Thanks!