AUTOFILTER-2 non-adjacent columns

[GaryW]

How do I create an autofilter for columns that are not next each other?
Example, COLUMN A and COLUMN C may be the only columns that are important for
my purpose on a spread-sheet.

 

[Max]

How do I create an autofilter for columns that are not next each other?
Example, COLUMN A and COLUMN C may be the only columns
that are important for my purpose on a spread-sheet.

You can't. I'd just live with this constraint.

Anyway, here's a sub that I came across that
you could try to "remove" the autofilter in col B
after it is applied to cols A to C.

Sub AutoFilterCustom()
Range("A1").AutoFilter Field:=2, VisibleDropDown:=False
End Sub

 

[GaryW]

Thanks, much. Saved me more time.

You can't. I'd just live with this constraint.

Anyway, here's a sub that I came across that
you could try to "remove" the autofilter in col B
after it is applied to cols A to C.

Sub AutoFilterCustom()
Range("A1").AutoFilter Field:=2, VisibleDropDown:=False
End Sub

 

[Max]

Welcome. Do spare a moment to press the "Yes" button below.