Forum Discussion
SpaceNorman
Aug 16, 2021Copper Contributor
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...
- Aug 16, 2021
Try
If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If
or
On Error Resume Next ActiveSheet.ShowAllData On Error GoTo 0
HansVogelaar
Aug 16, 2021MVP
Try
If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If
or
On Error Resume Next
ActiveSheet.ShowAllData
On Error GoTo 0