Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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