XL2002 - Group / Outline / ShowDetail...

[Trevor Williams]

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

 

[Don]

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.