Thread: Why can't i filter two different columns with different criterias like this
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Claus[_3_] Claus[_3_] is offline
external usenet poster
  
Posts: 40
Default Why can't i filter two different columns with different criterias like this
It works

Thank you

"DM Unseen" skrev i en meddelelse
ups.com...
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