Excel 2013 VBA Clear All Filters macro May 29, 2023 by Tarik Try this: If ActiveSheet.AutoFilterMode Then ActiveSheet.ShowAllData