Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the syntax for using the "IF" condition with an autofilte.
I want to write a macro that applies .AutoFilter to a range,
I have got this far " Selection.AutoFilter Field:=1, Criteria1:="#REF!", Operator:=xlAnd" BUT what is the syntax when "#REF!" does not apear in the filtered list so I can return the list to the original condition and not make any changes? Thank you Peter147 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the syntax for using the "IF" condition with an autofilte.
There is no such criteria, you filter using a criteria, I expect you would
have your macro to check if there are no ref errors before you apply the filter criteria. Maybe you could explain what you are trying to do in the first place and maybe someone here can answer that? -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "peter147" wrote in message ... I want to write a macro that applies .AutoFilter to a range, I have got this far " Selection.AutoFilter Field:=1, Criteria1:="#REF!", Operator:=xlAnd" BUT what is the syntax when "#REF!" does not apear in the filtered list so I can return the list to the original condition and not make any changes? Thank you Peter147 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a commission calculation chart w/ "if" condition? | Excel Worksheet Functions | |||
Syntax for using "IF"... | Excel Discussion (Misc queries) | |||
Syntax for using "IF"... | Excel Worksheet Functions |