Forum Discussion

SpaceNorman's avatar
SpaceNorman
Copper Contributor
Aug 16, 2021
Solved

Testing to Determine IF a Filter is active

I'm working on a spreadsheet that consists of two sheets - a "Transaction Log" that contains a list of expense records.  The second sheet is titled "New Summary" and is basically a "dashboard" that d...
  • HansVogelaar's avatar
    Aug 16, 2021

    SpaceNorman 

    Try

        If ActiveSheet.FilterMode Then
            ActiveSheet.ShowAllData
        End If

    or

        On Error Resume Next
        ActiveSheet.ShowAllData
        On Error GoTo 0

Resources