Could't find a solution? Ask the experts in our
Reset Auto Filter and unhide Rows and Columns using Excel VBA
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
- Login or register to post comments
- Feed: vbadb feed
- Original article
- 701 reads

