Easy VBA syntax

[normpam]

One more question...

For Each Cell In Range("Contact")
If Cell.Value = "I&S" Then
Cell.Offset(0, 1).Value = "No"
Cell.Offset(0, 2).Value = "Yes"
end if

The code works fine, but is it possible to include both outcomes in one line without a block if?

something like - If Cell.Value = "I&S" Then Cell.Offset(0, 1).Value = "No" And Cell.Offset(0, 2).Value = "Yes"

 

[offthelip]

yes you can , you need to use the colon : to separate the statements

If Cell.Value = "I&S" Then Cell.Offset(0, 1).Value = "No" : Cell.Offset(0, 2).Value = "Yes"

 

[Fluff]

Dupplicate https://www.mrexcel.com/forum/excel-questions/1085625-easy-vba-syntax-post5217008.html#post5217008

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).