Thread: Change criteria in a CF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CC CC is offline
external usenet poster
  
Posts: 91
Default Change criteria in a CF
Hi to all
I've did a CF like the example below
Selection.AutoFilter
Selection.AutoFilter Field:=3, Criteria1:="=*WARNING*", Operator:=xlAnd
Selection.AutoFilter Field:=9, Criteria1:="=*Pressure*", Operator:=xlAnd

Is possible change the criteria withoult change the macro e.g insert
the criteria word in a cell P1 .
Appreciate any help

CC

Reply With QuoteReply With Quote