Autofilters and hidden cells are a nemesis when you perform some operations. The following simple macro will unhide all rows/columns and turn-off the autofilter
Sub RemoveFiltersAndHiddenRows()
Dim oWS As Worksheet
For Each oWS In ActiveWorkbook.Sheets
oWS.AutoFilterMode = False
oWS.UsedRange.Rows.Hidden = False
oWS.UsedRange.Columns.Hidden = False Next
End Sub
Showing posts with label Remove Autofilter using VBA. Show all posts
Showing posts with label Remove Autofilter using VBA. Show all posts
Monday, April 27, 2009
Subscribe to:
Posts (Atom)
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
