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 |
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. |
All times are GMT +1. The time now is 05:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com