LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Row Colour if certain criteria is met Steven Excel Worksheet Functions 2 May 6th 09 01:43 PM
auto set time(now) if criteria=true with no later change Rafi Benami Excel Worksheet Functions 1 April 24th 07 05:57 AM
Change text based on other cell criteria? ansoriano1 Excel Worksheet Functions 2 August 23rd 06 12:02 AM
Based on one cell criteria to change the rest of that row to a col Rochelle B Excel Discussion (Misc queries) 7 November 13th 05 02:42 AM
how do I change the font of a cell if it meets a certain criteria. Meaux Excel Worksheet Functions 3 November 19th 04 06:05 AM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"