I'm looking to create a macro to switch off an active filter on a specific page. The button for the macro will be placed on a different worksheet named "G and O Analysis", the active filter is open on the next sheet named "EPL". I'm basically just looking for a code to turn off the filter across all columns on the "EPL" sheet.
Thanks.
Last edited by Consty1; 06-16-2013 at 09:36 AM.
No problem, I've figured it out.
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Ok no worries. To turn off the filter on the specific sheet it's simply
Formula:
Sub RemoveFilter()
Sheets("EPL").AutoFilterMode = False
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Consty1 
Register To Reply
Bookmarks