top of page

Excel Macro to Unfilter Data on Multiple Worksheets

See this macro which will unfilter data on multiple worksheets.

Sub Unfilter() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.AutoFilterMode = False Next ws End Sub

Just insert in a module and run it. It can be a useful tool in processing data for production.

bottom of page