VBA Autofilter Not Equal multiple criteria

[BrianM]

Hello,
I'm currently using the following to filter multiple criteria 'Equal to':

    Dim ar As Variant
    Dim lngLastRow As Long
      
    Range("A1").AutoFilter 'Turn Filter On
    ar = Array("1", "2", "3", "4", "5", "6", "8", "9", "C", "N", "P", "Q", "R", "Y")
    Range("A1", Range("A" & Rows.count).End(xlUp)).AutoFilter 13, ar, xlFilterValues, , 0

How can I turn it into a 'Not Equal to' statement? I've tried "=<>1", "=<>2" etc, but that fails.

Thanks,
Brian

 

[Fluff]

You can only filter on more than two values when using an exact match.
You have 3 options
1) Look at using advanced filters instead.
2) Put a formula in a blank column that returns true or false depending on whether that row should be visible & filter on that.
3) create an array of values that should be visible.