View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil H[_2_] Phil H[_2_] is offline
external usenet poster
 
Posts: 87
Default Turn Filters On and Off

The below code successfully adds AutoFilters to the selection. How do I
remove the AutoFilters? Tried recording a macro but the code is the same as
for adding filters.

Private Sub CommandButton4_Click()
'Command Button: "Add Filters"
Application.ScreenUpdating = False
Range("B3:I3").Select
Selection.AutoFilter
Application.ScreenUpdating = True
End Sub