If does not equal VBA

[Godders199]

I have the following code that selects rows where the criteria is met, I want to change this so it looks for rows in column 11 not containing X, y, z for example

If Worksheets("submissions").Cells(i, 11).Value ="Godders" And Worksheets("submissions").Cells(i, 21).Value= "" Then
I know i need to change value = "godders" to <> X

but do i need t create a if command for each, or can i combine X, Y , Z into one statement?

Any help would be appreciated.

 

[Joe4]

I think this may be what you are looking for:

[COLOR=#000000][FONT=Calibri]If Worksheets("submissions").Cells(i, 11).Value <>"X" And _
[/FONT][/COLOR][COLOR=#000000][FONT=Calibri]    Worksheets("submissions").Cells(i, 11).Value <>"Y" And _
[/FONT][/COLOR][COLOR=#000000][FONT=Calibri]    Worksheets("submissions").Cells(i, 11).Value <>"Z" And _
[/FONT][/COLOR][COLOR=#000000][FONT=Calibri]    Worksheets("submissions").Cells(i, 21).Value= "" Then[/FONT][/COLOR]

 

[RoryA]

You could reverse the logic:

Select Case Worksheets("submissions").Cells(i, 11).Value
   Case "X", "Y", "Z"
      ' ignore
   Case Else
     If Worksheets("submissions").Cells(i, 21).Value= "" Then
        ' do something
     End If
End Select

 

[Godders199]

thanks alot