Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To switch off a range AutoFilter, you use the AutoFilter method of the Range object with no parameters

Sub autoFilter()      range("B3:D9").autoFilter End Sub