Using autofilters on discontiguois range of cells along a row.

[Tony_Caliente]

Hi! I would like to apply filters (funnels) to the following cell A9 to H9. and 09 using a macro launched by clicking on a shape.

Can this be done without filtering cells I9 through N9?

Thank you!

[LalitPandey87]

No for Autofilter as it will not allow you to filter data based on multiple selection but we can manage data filter part by using VBA UDF.

[p45cal]

You can filter the whole A9:O9 range but hide the drop down arrows from any number of (even all) columns. Would this do?

[p45cal]

You can filter the whole A9:O9 range but hide the drop down arrows from any number of (even all) columns. Would this do?This snippet will hide the dropdown arrows of any existing autofilter on the active sheet for columns I to N:
FieldNo = 1
For Each colm In ActiveSheet.AutoFilter.Range.Columns
If colm.Column > 8 And colm.Column < 15 Then
colm.AutoFilter field:=FieldNo, visibledropdown:=False
End If
FieldNo = FieldNo + 1
Next colm