AUTOFILTER-2 non-adjacent columns

  • Thread starter Thread starter GaryW
  • Start date Start date
G

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.
 
GaryW said:
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

---
 
Thanks, much. Saved me more time.

Max said:
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

---
 
Back
Top