View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?