Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhide columns and rows
Hi all,
could anybody help me to find whether any of the columns or rows are hide or not? If so, is there any way to unhide those (through macro) Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhide columns and rows
Do you really have to check first?
Maybe just showing the rows/columns would be enough: Option Explicit Sub testme() With Worksheets("Somesheetnamehere").UsedRange .Rows.Hidden = False .Columns.Hidden = False End With End Sub Rod wrote: Hi all, could anybody help me to find whether any of the columns or rows are hide or not? If so, is there any way to unhide those (through macro) Thanks in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhide columns and rows
To test:
RowStatus = Range("2:2").EntireRow.Hidden ColumnStatus = Range("A:A").EntireColumn.Hidden To unhide: Range(1:65536).EntireRow.Hidden = False Range("A:IV").EntireColumn.Hidden = False -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rod" wrote: Hi all, could anybody help me to find whether any of the columns or rows are hide or not? If so, is there any way to unhide those (through macro) Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One-click hide or unhide rows & columns | Excel Worksheet Functions | |||
Why do hidden columns/rows unhide automatically? | Excel Discussion (Misc queries) | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
Lines separating rows and columns won't unhide | Excel Discussion (Misc queries) |