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" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks, much. Saved me more time.

"Max" wrote:

"GaryW" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Welcome. Do spare a moment to press the "Yes" button below.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GaryW" wrote:
Thanks, much. Saved me more time.