Hi,
when I run the below code it works fine unless the filter has been deactivated and then it will go into the debug mode. Is it possible to bring up a message box instead to prevent this?
Sub Clear_filter() ' ' Clear_filter Macro ' ' Sheets("data").Select ActiveSheet.ShowAllData Sheets("Collar").Select End Sub
Bookmarks