I have the following code below to unhide Cols & Rows on all sheets,
However, when running the code, I get a run time error "unable to set the hidden property of the range class "
The code below is highlighted
It would be appreciated if someone could kindly amend my code
Code:
Sub Unhide_ColumnsRows_On_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Cells.EntireColumn.Hidden = False
ws.Cells.EntireRow.Hidden = False
Next ws
End Sub
However, when running the code, I get a run time error "unable to set the hidden property of the range class "
The code below is highlighted
Code:
ws.Cells.EntireColumn.Hidden = False
It would be appreciated if someone could kindly amend my code