How to select multiple criteria from same column?
How can I select multiple criteria from the same column?
The following code works fine for single criteria (I added one line code in red font but it filters only the West region data):
Sub FilterRegion()
With Sheet1
.AutoFilterMode = False
.Range("A2:N2").AutoFilter
.Range("A2:N2").AutoFilter Field:=1, Criteria1:="East"
.Range("A2:N2").AutoFilter Field:=1, Criteria1:="West" 'How to modify the code here.
End With
End Sub
|