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.


Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com