Using autofilters on discontiguois range of cells along a row.

[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