Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If autofilter is on, then..
Guys,
My Macro needs to autofilter on row 2. Problem is I need to tell Excel to look whether there currently is an existing autofilter on or not. (My code below says selction.autofilter - ie if there is NO autofilter it correctly turns Autofilter on and works fine, BUT sometimes there is an existing autofilter turned on, so all the code does is turn the existing autofilter off, ie it does nothing. Ideas...? Thanks D sub filter 'turn autofilter on ActiveSheet.Select Rows("2:2").Select Selection.AutoFilter Selection.AutoFilter Field:=4, Criteria1:="ASPAC" Range("c3").Select End sub *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If autofilter is on, then..
If you're going to add the autofilter arrows, you can remove them first:
activesheet.autofiltermode = false It won't hurt if there is no filter applied, too. Then just apply it where you want. Darin Kramer wrote: Guys, My Macro needs to autofilter on row 2. Problem is I need to tell Excel to look whether there currently is an existing autofilter on or not. (My code below says selction.autofilter - ie if there is NO autofilter it correctly turns Autofilter on and works fine, BUT sometimes there is an existing autofilter turned on, so all the code does is turn the existing autofilter off, ie it does nothing. Ideas...? Thanks D sub filter 'turn autofilter on ActiveSheet.Select Rows("2:2").Select Selection.AutoFilter Selection.AutoFilter Field:=4, Criteria1:="ASPAC" Range("c3").Select End sub *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If autofilter is on, then..
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |