Navi
Member
Hi Team, need your help here.
I have a set of data saved as array in macro and I have named the array as cbox.
currently I need to filter a column with criteria which are not equal to the array value (> Cbox). Am not getting the result . please help.
Below the current code.
Regards,
Navi
I have a set of data saved as array in macro and I have named the array as cbox.
currently I need to filter a column with criteria which are not equal to the array value (> Cbox). Am not getting the result . please help.
Below the current code.
Code:
If Not .AutoFilterMode Then
Set cel = Range("A1").CurrentRegion
i = Application.WorksheetFunction.Match("Deptt", Range("A1:B10"), 0)
cel.AutoFilter Field:=i, Criteria1:=Array("*cBox*"), Operator:=xlFilterValues
End If
Regards,
Navi
Last edited by a moderator: