Using Or statements

[kckay]

How should I write this code?

.
.
        Heading_Count = 2
        Row_Count = 5
        Source_Count = 28
        
        For n = 1 To Number_Of_Rows
            If Worksheets("System Overview").Range("C" & Source_Count).Value = "NP" Or _
                "NN" Or _
                "SI" Or _
                "RS" Or _
                "RC" Or _
                "CS" Or _
                "IN" Or _
                "WL" Or _
                "IG" Or _
                "SP" Then
'--------------------------------------------------
'WSF Number
'--------------------------------------------------
.
.
.

 

[mikerickson]

To use IF in that way the syntax would be

If Worksheets("System Overview").Range("C" & Source_Count).Value = "NP" Or _
       Worksheets("System Overview").Range("C" & Source_Count).Value = "NN" Or _
       Worksheets("System Overview").Range("C" & Source_Count).Value = "SI" Or _
       Worksheets("System Overview").Range("C" & Source_Count).Value = "RS" Then
    Rem do stuff
End If

an easier syntax would be

Select Case Worksheets("System Overview").Range("C" & Source_Count).Value
    Case "NP", "NN", "SI", "RS"
       Rem do stuff
End Select