I just need a sinmple macro that will clear all filters in a table. If the table is called Table1, could someone kindly help me out? I can easily do it by recording a macro, but as soon as the columns change, it won't work. I don't know enough about VBA to do it myself...
Try this'
ActiveSheet.ListObjects("YourTableName").Range.AutoFilter
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Great, only problem is it removes the filter buttons as well, not resets them.
O this should do it
ActiveSheet.ListObjects("TableName").AutoFilter.ShowAllData
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks