| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide Rows or Columns
Hi,
How can I Hide/Unhide rows/columns or a ranges? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide/Unhide Rows or Columns
You can't hide a range, but you can hide colums and rows:
Some examples: Columns("E:F").EntireColumn.Hidden = True Columns("D:G").EntireColumn.Hidden = False Rows("8:8").EntireRow.Hidden = True 2007-User wrote: Hi, How can I Hide/Unhide rows/columns or a ranges? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide/Unhide Rows or Columns
Rows/Columns yes, range no
rows("1:10").hidden=true columns("D:H").hidden = true -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "2007-User" wrote in message ... Hi, How can I Hide/Unhide rows/columns or a ranges? Thanks in advance. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide/Unhide Rows or Columns
Thanks Guys.
"Bob Phillips" wrote in message ... Rows/Columns yes, range no rows("1:10").hidden=true columns("D:H").hidden = true -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "2007-User" wrote in message ... Hi, How can I Hide/Unhide rows/columns or a ranges? 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 | |||
| Excel 2007 - Hide & Unhide Columns/Rows | Excel Discussion (Misc queries) | |||
| Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
| How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
| How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) | |||
Hybrid Mode
