BombSheels
New Member
- Joined
- Apr 16, 2021
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hello, i have an excel macro file which I need to filter to 2 different criteria.
Criteria1 filter current year
Criteria2 filter specific words
But upon running the macro, it only displays 1 criteria
kindly help me. thank you
Criteria1 filter current year
Criteria2 filter specific words
But upon running the macro, it only displays 1 criteria
VBA Code:
With Sheet2.Range("A1:F50000")
.AutoFilter Field:=6, _
Operator:=xlFilterDynamic, _
Criteria1:=xlFilterThisYear
.AutoFilter Field:=6, _
Criteria2:=Array("INCLUDE", "INCLUDE SA"), _
Operator:=xlFilterValues
End With
kindly help me. thank you
Last edited by a moderator: