Created
March 11, 2018 04:19
-
-
Save DavidMetcalfe/3bcd97cc591765087e41fe65cbd4873a to your computer and use it in GitHub Desktop.
Various permutations of negative matching in Excel VBA
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="=NULL", Operator:=xlAnd 'EQUALS "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="<>NULL", Operator:=xlAnd 'DOES NOT EQUAL "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="=NULL*", Operator:=xlAnd 'BEGINS WITH "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="<>NULL*", Operator:=xlAnd 'DOES NOT BEGIN WITH "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="=*NULL", Operator:=xlAnd 'ENDS WITH "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="<>*NULL", Operator:=xlAnd 'DOES NOT END WITH "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="=*NULL*", Operator:=xlAnd 'CONTAINS "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="<>*NULL*", Operator:=xlAnd 'DOES NOT CONTAIN "NULL" | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="=" 'Blanks | |
| 'ActiveSheet.Range("Database").AutoFilter Field:=1, Criteria1:="<>" 'NonBlanks |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment