For example:
![]()
Sub ShowAll() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets With wks If .AutoFilterMode Then If .FilterMode Then .ShowAllData End If End With Next wks End Sub
For example:
![]()
Sub ShowAll() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets With wks If .AutoFilterMode Then If .FilterMode Then .ShowAllData End If End With Next wks End Sub
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks