HELP!!!!! VB Question

Posted by Ben Adams on October 04, 2001 2:20 PM

I want to turn autofilter off if autofilter is on.
How do I do this with a VB if-then statement. I tried this but it didn't work!????

If selection.autofilter then
selection.autofilter
End If

Posted by Anon on October 04, 2001 2:40 PM

If Selection.Parent.AutoFilterMode Then Selection.AutoFilter

Posted by Jim on October 04, 2001 5:22 PM

Hi Ben,
Possibly:
Private Sub()
If Selection.autofilter = True Then
Selection.autofilter = False
End If
End Sub

I want to turn autofilter off if autofilter is on.