Jim,

I want to remove the filter for several columns (for example columns 4 thru
8), how can I modify your macro to do this?

I've tried a few things, but can't seem to get the syntax right, can you help?

Thanks




"Jim Rech" wrote:

You can have only one autofilter at a time in a worksheet. You can make some
of the dropdowns disappear though, which may be what you want, but only by a
macro as far as I know. This assumes the autofilter is already in place:

ActiveSheet.AutoFilter.Range.AutoFilter field:=3, visibledropdown:=False

--
Jim Rech
Excel MVP
"wladdr" wrote in message
...
| How do I put AutoFilter on just a couple of non adjacent columns in a
| worksheet. I know I've seen this, and maybe have done it before, but now I
| get a "...cannot be performed with multiple selections..." error. Thank
you.