Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XL2002 - Group / Outline / ShowDetail...
Hello All
I have 4 groups of rows on a sheet and want vba to return whether each one is expanded or collapsed. Any suggestions? Thanks Trevor Williams |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XL2002 - Group / Outline / ShowDetail...
On May 13, 6:15*am, Trevor Williams
wrote: Hello All I have 4 groups of rows on a sheet and want vba to return whether each one is expanded or collapsed. Any suggestions? Thanks Trevor Williams First, you must apply a name to the cells that can be hidden for each group. Then you can return the hidden property of each range with the following line of code. I have used the range that I have designated "MyGroup1". MsgBox Range("MyGroup1").EntireRow.Hidden Replace MsgBox with a variable where you want to store the property. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
group and outline | Excel Discussion (Misc queries) | |||
Under data/Group&outline/group | Excel Discussion (Misc queries) | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
Group and Outline | New Users to Excel | |||
Group and Outline | Excel Discussion (Misc queries) |