Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Autofilter
Hi all, I am trying to autofilter on a worksheet but have trouble if th autofilter is already on. Basically what I want: If the autofilter is on then I would like t turn if off, but if the filter is off then I would like to leave i off. I currently use selection.autofilter and have trouble with this; if th autofilter is on it turns it off and if its off it turns it on. This i causing massive issues with the rest of the macro running. Please hel -- moglione ----------------------------------------------------------------------- moglione1's Profile: http://www.excelforum.com/member.php...fo&userid=2641 View this thread: http://www.excelforum.com/showthread.php?threadid=53837 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Autofilter
Hi Moglione,
Try: ActiveSheet.AutoFilterMode = False --- Regards, Norman "moglione1" wrote in message ... Hi all, I am trying to autofilter on a worksheet but have trouble if the autofilter is already on. Basically what I want: If the autofilter is on then I would like to turn if off, but if the filter is off then I would like to leave it off. I currently use selection.autofilter and have trouble with this; if the autofilter is on it turns it off and if its off it turns it on. This is causing massive issues with the rest of the macro running. Please help -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=538373 |
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) |