Table of Contents
Hide Specific Row/Rows of a Worksheet
Sub HideRows() Rows("5:10").EntireRow.Hidden = True End Sub
Unhide Specific Row/Rows of a Worksheet
Sub UnHideRows() Rows("5:10").EntireRow.Hidden = False End Sub
Unhide Every hidden Row of a Worksheet
Sub UnhideAllRows() Cells.EntireRow.Hidden = False End Sub
Hide Specific Column/Columns of a Worksheet
Sub HideColumns() Columns("B:D").EntireColumn.Hidden = True End Sub
Unhide Specific Column/Columns of a Worksheet
Sub UnHideColumns() Columns("B:D").EntireColumn.Hidden = False End Sub
Unhide Every hidden Column of a Worksheet
Sub UnhideAllColumns() Cells.EntireColumn.Hidden = False End Sub