Thread: Why can't i filter two different columns with different criterias like this
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
  
Posts: 1,298
Default Why can't i filter two different columns with different criterias
Range("E4:AI183").Select
Selection.AutoFilter Field:=1, Criteria1:=Leverandor
Selection.AutoFilter Field:=35, Criteria1:="<"

be sure that the word Leverandor is a string variable with a value or wrap
it in quotes -- "Leverandor"
Reply With QuoteReply With Quote