Using autofilters on discontiguois range of cells along a row.

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!

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.

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

Quote:

---

Originally Posted by 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:

Code:

---

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

---