Home > VBAUsefulCodes
displays hidden rows or removes hidden property from the rows, so that all the rows which are hidden already will be visible now.
Unhide all Rows in Excel VBA
displays hidden rows or removes hidden property from the rows, so that all the rows which are hidden already will be visible now.
Sub Unhide_All_Rows()
On Error Resume Next
'in case the sheet is protected
ActiveSheet.Cells.EntireRow.Hidden = False
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts