Unhide all columns and rows
A short macro that will unhide all columns and rows in order to make all data visible again.
Might be useful in some cases.
Sub UnhideAllColumnsRows()
' unhide all columns and rows on the current worksheet
Cells.EntireColumn.Hidden = False
Cells.EntireRow.Hidden = False
End Sub
' unhide all columns and rows on the current worksheet
Cells.EntireColumn.Hidden = False
Cells.EntireRow.Hidden = False
End Sub
If you want more control on which rows and/or columns to unhide, you can also use this tool from within ASAP Utilities.
Related Posts