Thread: Why can't i filter two different columns with different criterias like this
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
  
Posts: 233
Default Why can't i filter two different columns with different criterias like this
Claus

use the following code:

with Range("E4:AI183").
.AutoFilter Field:=1, Criteria1:=Leverandor,
VisibleDropDown:=False
.AutoFilter Field:=35, Criteria1:="<",
VisibleDropDown:=False
end with

DM Unseen

Reply With QuoteReply With Quote