Selective Autofilter Application

M

Maurice

When I apply the autofilter funtion, it does so accross all existing columns
of my worksheet. Is it possible to apply this functionality to only a few
selected columns, and how do I go about it ?

Kind regards
 
J

JR

....just highlight the columns that you want to apply the autofilter to, then
select autofilter.
 
M

Maurice

Hi JR,

I actually tried that before the post, but it didn't work for some reason.
When selecting the 2nd column, it simply undoes the first. Also, selecting a
few via Ctrl, also won't allow you. What do you think is potting ? I run
Excel 2002.
 
M

Maurice

Fred,

As per my reply to JR, your suggestion does not work either. That's what I
find so strange. Would have thougt this to be rather "elementary" stuff ?
 
D

Debra Dalgleish

You can apply an AutoFilter to the entire table, then hide some arrows
with programming. For example, the following code leaves arrows visible
only on columns 2, 3 and 7.

'======================
Sub HideSomeArrows()
'hide some autofilter arrows
Dim c As Range
Dim i As Integer
i = Cells(1, 1).End(xlToRight).Column
Application.ScreenUpdating = False
For Each c In Range(Cells(1, 1), Cells(1, i))
Select Case c.Column
Case 2, 3, 7
c.AutoFilter Field:=c.Column, _
Visibledropdown:=True
Case Else
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False
End Select
Next
Application.ScreenUpdating = True
End Sub
'====================
 
M

Maurice

Hi Debra,

Finally, some advice that actually works !. Thank you ever so kindly, it is
much apreciated. In the absense of any easier method, I will simply continue
to use the macro you provided.

PS. I still haven't been able to determine why the other advise given, did
not work. This seems such a simple function, or perhaps not ? Is there
something wrong my end, or is it a case that MS Excel simply do not possess
the required functionality. Surely I can't be the first person to have this
particular need.

Anyway, many thanks again for resolving my problem. Wish there was a
resource where I could learn more about writing a macro.

Kind regards
Maurice
 
Top