+ Reply to Thread
Results 1 to 3 of 3

VBA to apply & remove filters

  1. 09-25-2012, 10:00 AM #1
    kenadams378
    kenadams378 is offline
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    VBA to apply & remove filters

    Is their a peice of code i can use to remove all filters from selected excel sheets?
    Reply With QuoteRegister To Reply
  2. 09-25-2012, 10:14 AM #2
    ptm0412
    ptm0412 is offline
    Forum Contributor ptm0412's Avatar
    Join Date
    04-16-2008
    Location
    Vietnam
    MS-Off Ver
    Office 2003 and 2007
    Posts
    129

    Re: VBA to apply & remove filters

    PHP Code: 
    Sub abc()
    For     Each Sh In ThisWorkbook.Sheets
        Sh    .AutoFilterMode = False
    Next
    End Sub 
    Oldman Chatting: [email protected] Mailing: [email protected]
    Reply With QuoteRegister To Reply
  3. 09-25-2012, 10:17 AM #3
    kenadams378
    kenadams378 is offline
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Re: VBA to apply & remove filters

    MAny Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1