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