Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
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.
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.