AUTOFILTER skipping columns

[vlsi99]

Hi:

Background (just an Excel user not a programmer)

I have a Spreadsheet with 20 columns across and 100 rows.
I want to add the autofilter button only to certain columns (skipping columns).

So far , the only way I know how to limit the number of columns with the autofilter on is by selecting consecutive columns.

My goal is to have for example:

Columns:


A (with filter buttom), B(with filter buttom), C(no filter Button), D(with filter button)



Is this possible?

thanks

Sergio

 

[tactps]

Autofilter can only be used on consecutive columns. I suggest that you either:
1. Hide the columns that aren't required
2. Reorder the columns so that the ones not required are out of the range
3. Live with it
4. Use a data validation in a separate column to give you your drill-down.

 

[Tom Urtis]

I want to add the autofilter button only to certain columns (skipping columns).My goal is to have for example:
Columns:
A (with filter buttom), B(with filter buttom), C(no filter Button), D(with filter button)
Is this possible?

Yes it is possible with VBA, by invoking AutoFilter's VisibleDropDown argument and setting it to False where you want.

For example, running this macro would give you the drop-downs where you said you want them (A, B, and D), and omit it from C. This assumes your header row is 1.


Sub Test1()
With Range("A1")
.CurrentRegion.AutoFilter
.AutoFilter Field:=3, VisibleDropDown:=False
End With
End Sub