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