Consulting

Results 1 to 3 of 3

Thread: reset filter mode

  1. 01-05-2006, 07:53 AM #1
    lior03
    lior03 is offline
    VBAX Mentor
    Joined
    Jun 2005
    Posts
    374
    Location

    reset filter mode

    hello
    i have a filtered sheet .how do i reset it back to off
    using vba?
    thanks
    moshe
    Reply With Quote Reply With Quote
  2. 01-05-2006, 08:15 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    [vba]
    If ActiveSheet.AutoFilterMode Then
    Cells.AutoFilter
    End If
    [/vba]
    Reply With Quote Reply With Quote
  3. 01-05-2006, 08:16 AM #3
    matthewspatrick
    matthewspatrick is offline
    VBAX Expert
    Joined
    Jul 2004
    Location
    Wilmington, DE
    Posts
    600
    Location
    [VBA] If Not ActiveSheet.AutoFilter Is Nothing Then [a1].AutoFilter[/VBA]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules