Help: VBA code to uncheck more than 3 values from Filter

[Mahantesh]

Hi Guru's,

I have below table. I need VBA code to uncheck the TAX, ONLINE and FREIGHT from filter.



I tried by putting Criteria in Autofilter range. But failed as VBA does allow more than 2 criteria in Autofilter method.

Can anyone please help me and solving this VBA code to uncheck more than 3 values?

Regards,
Mahantesh
__________________________________________________________________

Mod edit : thread moved to appropriate forum !​

 

[PCosta87]

Hi @Mahantesh

You can use advanced filters to accomplish what you want... the thing is you will not be unchecking but rather selecting all the others...

Take a look at this:
http://forum.chandoo.org/threads/ap...-below-other-in-next-sheet.32028/#post-190129

Post #8

Regards

 

[PCosta87]

@Mahantesh

I saw you posted in the other thread but I believe it is best if we keep things separate as mixing may cause some confusion if someone comes looking for that specific solution:

In your case, with table in columns A:B and criteria in column H, you can use the following code:

Sub Macro()

    Dim lrow As Integer
    lrow = Columns("H").Cells(Rows.Count).End(xlUp).Row

    Columns("A:B").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
        ActiveSheet.Range("H1:H" & lrow), Unique:=False

End Sub

Please see attached

Regards

 

[PCosta87]

Also... maybe this should be moved to VBA section

Thks