![]() |
|
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Do it manually while recording with the macro recorder and have a look at the code it produces.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need to count based on multiple criteria in multiple columns | rachaels54 | Excel | 1 | 04-18-2017 03:20 PM |
![]() |
phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
Select value from table based on two criteria | gebobs | Excel | 4 | 07-21-2016 08:26 AM |
![]() |
AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
![]() |
flds | Excel Programming | 5 | 09-30-2014 09:58 AM |