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...
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Aug 16, 2021

    SpaceNorman 

    Try

        If ActiveSheet.FilterMode Then
        ActiveSheet.ShowAllData
    End If

    or

        On Error Resume Next
    ActiveSheet.ShowAllData
    On Error GoTo 0
SpaceNorman's avatar
SpaceNorman
Copper Contributor
Aug 16, 2021
I went the "If Then" route (Figuring it was better to avoid generating the error in the first place) and it solved my problem! Thank you for the quick feedback! Your help is truly appreciated.

Resources