Hi,
Is it possible to unhide all rows and columns in a workbook?
Any suggestions gratefully received,
Mike
Unhide ALL cells, rows and columns
-
-
-
Hi Mike,
How about:[vba]Sub Unhide_All_Rows()
On Error Resume Next
'in case the sheet is protected
ActiveSheet.Cells.EntireRow.Hidden = False
End SubSub Unhide_All_Columns()
On Error Resume Next
'in case the sheet is protected
ActiveSheet.Cells.EntireColumn.Hidden = False
End Sub[/vba]HTH -
Do you want a manual or VBA solution?
manually you can select all cells by clicking the grey box at the left between A & 1. Then use the Format Menu to unhide.
-
I think I need a VBA solution, as I would like to do it for all sheets in the workbook.
Actually, the reason why is that I have noticed a problem/bug with hiding rows. Where all rows beneath a chosen area have been hidden, so that the available excel window is reduced - i.e. it doesn't scroll all the way to row 65536 - it doesn't seem possible to unhide these rows.
Example:
In the attached sheet, it is not possible to unhide any rows past 67, effectively limiting excel.
Anybody experienced this before or knows a fix?
**EDIT - Can't attach file as it is 75KB despite having nothing visible (cleared all formats and values) **
-
Have you run Richie's code?
-
Yes. All very strange.
It appears that I have somehow tricked excel into redefining the range...
Does anybody have storage that I can post the file to?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!