Forum Discussion
Clear Filter with a button
I am only a "medium" excel guy, please be patient.... I have added a button to a spreadsheet that has columns that can be filtered. I have assigned the "clear" function/macro to the button. How...
Kenneth-
Do you have the code snippet you're using? You probably just need to add in some Error Handling or incorporate this small portion of code at the top of the procedure that suppresses errors (Note: this statement should be used with caution):
On Error Resume Next
Here is some more information on Error Handling by Chip Pearson:
http://www.cpearson.com/excel/errorhandling.htm