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?

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?

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?