BrianM
Well-known Member
- Joined
- Jan 15, 2003
- Messages
- 768
- Office Version
- 2016
- Platform
- Windows
Hello,
I'm currently using the following to filter multiple criteria 'Equal to':
How can I turn it into a 'Not Equal to' statement? I've tried "=<>1", "=<>2" etc, but that fails.
Thanks,
Brian
I'm currently using the following to filter multiple criteria 'Equal to':
VBA Code:
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