VBA Autofilter

M

moglione1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If autofilter is on, then.. 2
Autofilter based on user inputbox 3
Autofilter problem 7
Autofilter sorting. 3
Accessing the AutoFilter method via VB.net 3
Autofilter in a macro 1
Turn off Autofilter but leave rows hidden. 3
Copying nothing/everything when an autofilter returns no results? XL2003 1

Top