Try this:
If ActiveSheet.AutoFilterMode Then ActiveSheet.ShowAllData
More Related Contents:
- Dir() function not working in Mac Excel 2011 VBA
- VBA Shell function in Office 2011 for Mac
- VBA (Excel) Dictionary on Mac?
- Create a folder and sub folder in Excel VBA
- Checking if a worksheet-based checkbox is checked
- How do I issue an HTTP GET from Excel VBA for Mac
- How can I install/use “Scripting.FileSystemObject” in Excel 2010 for MAC?
- The MacScript function is not working well in Office for Mac 2016! Any ideas?
- How do you change the value of a cell in excel by clicking on it using VBA? [closed]
- How to avoid using Select in Excel VBA
- Convert Text to Date?
- Run Excel Macro from Outside Excel Using VBScript From Command Line
- Importing text file into excel sheet
- Loop through each cell in a range of cells when given a Range object
- Checking for #N/A in Excel cell from VBA code
- Non-web SQL Injection
- Error: “Could Not Find Installable ISAM”
- Filling any empty cells with the value above
- hiding formulas in formula bar
- How to delete multiple rows without a loop in Excel VBA
- VBA Many buttons point to the same _Click sub
- Sorting a dictionary by key in VBA
- VBA paste as values – how to
- What are the benefits of using Classes in VBA? [closed]
- Writing a VLOOKUP function in vba
- Handle cancellation of InputBox to select range
- Type Mismatch in Loop to scan Outlook Messages [duplicate]
- VBA: How to combine two ranges on different sheets into one, to loop through
- Delete all data rows from an Excel table (apart from the first)
- Excel VBA Run-time Error ‘32809’ – Trying to Understand it