Thread: Why can't i filter two different columns with different criterias like this
View Single Post
  #1   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
Hi
Range("E4:AI183").Select
Selection.AutoFilter Field:=1, Criteria1:=Leverandor,
VisibleDropDown:=False
Selection.AutoFilter Field:=35, Criteria1:="<",
VisibleDropDown:=False

It works without the third line.

I'm getting an error (1004) on the third line.

Regards,
Claus



Reply With QuoteReply With Quote