"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
---