View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default AUTOFILTER-2 non-adjacent columns

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