Home > VBAUsefulCodes
displays hidden columns or removes hidden property from the columns, so that all the columns which are hidden already will be visible now
Unhide all Columns in Excel VBA
displays hidden columns or removes hidden property from the columns, so that all the columns which are hidden already will be visible now
Sub Unhide_All_Columns()
On Error Resume Next
'in case the sheet is protected
ActiveSheet.Cells.EntireColumn.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