1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Vba Check If Filter Is On And Turn Off

[Solved] Vba Check If Filter Is On And Turn Off | Vb - Code Explorer | yomemimo.com
Question : vba check if filter is on and turn off

Answered by : joepy-riba

Public Sub ClearFilter()
  If ActiveSheet.FilterMode = True Then    ActiveSheet.ShowAllData
  End If
End Sub

Source : https://www.automateexcel.com/vba/turn-autofilter-on-off/ | Last Update : Thu, 19 May 22

Answers related to vba check if filter is on and turn off

Code Explorer Popular Question For Vb