XL2002 - Group / Outline / ShowDetail...

  • Thread starter Thread starter Trevor Williams
  • Start date Start date
T

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
 
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
Click to expand...

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.
 
Back
Top