View Single Post
 
Old 03-10-2018, 07:23 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2013
Advanced Beginner
 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default 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
Reply With Quote