Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter code help
Here is a code:
Selection.AutoFilter Field:=18, Criteria1:=Sheets ("Code").Range("J2").Value This code works fine; however, I need it to filter to everything that does not equeal Sheets("Code").Range ("J2").Value not everything that equals it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter code help
Selection.AutoFilter Field:=18, Criteria1:="<" & Sheets _
("Code").Range("J2").Value -- Regards, Tom Ogilvy "scrabtree" wrote in message ... Here is a code: Selection.AutoFilter Field:=18, Criteria1:=Sheets ("Code").Range("J2").Value This code works fine; however, I need it to filter to everything that does not equeal Sheets("Code").Range ("J2").Value not everything that equals it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter code help
Tom gave you the answer, but remember that you can turn on the macro recorder
before you set up the filter. It will give you the appropriate commands. On Sun, 1 Aug 2004 13:54:49 -0700, "scrabtree" wrote: Here is a code: Selection.AutoFilter Field:=18, Criteria1:=Sheets ("Code").Range("J2").Value This code works fine; however, I need it to filter to everything that does not equeal Sheets("Code").Range ("J2").Value not everything that equals it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to replace Advanced Filter | Excel Discussion (Misc queries) | |||
Filter isn't working with a VBA Code | Excel Worksheet Functions | |||
Filter Code | Excel Programming | |||
vba filter code | Excel Programming | |||
Apply more than one filter in macro/vb code | Excel Programming |