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