Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Turns off the drop-downs for Columns C, E, F, G, and H
Sub AutoFilterCustom()
    range("A1").autoFilter Field:=3, VisibleDropDown:=False
    range("A1").autoFilter Field:=5, VisibleDropDown:=False
    range("A1").autoFilter Field:=6, VisibleDropDown:=False
    range("A1").autoFilter Field:=7, VisibleDropDown:=False
    range("A1").autoFilter Field:=8, VisibleDropDown:=False
End Sub