alsharif
New Member
- Joined
- Mar 14, 2021
- Messages
- 14
- Office Version
- 2019
- Platform
- Windows
Hi brothers,
Need your urgent help in correcting the below code to be able to use it to filter on column based on multiple colors:
ActiveSheet.Range("A1").AutoFilter Field:=6, Criteria1:=RGB(51, 63, 79), Criteria2:=RGB(255, 242, 204), Operator:=xlFilterCellColor
the code above only filter one color I put two criteria to tilter two colors !!
Note: I do not want to use color index method .
Thanks in advance brothers
Need your urgent help in correcting the below code to be able to use it to filter on column based on multiple colors:
ActiveSheet.Range("A1").AutoFilter Field:=6, Criteria1:=RGB(51, 63, 79), Criteria2:=RGB(255, 242, 204), Operator:=xlFilterCellColor
the code above only filter one color I put two criteria to tilter two colors !!
Note: I do not want to use color index method .
Thanks in advance brothers