I have a workbook that has either autofilters or advanced filters in it and a button called "Show All" that I would like to show all the data and remove the autofilter. My code (below) doesn't have an error catch if there is no filter when they click on the button and if it's an autofilter, it shows all but doesn't remove the autofilter (I have to click on the button twice). Here's my code;I'm working in Excel 2000. Thanks in advance.![]()
Please Login or Register to view this content.
Bookmarks