drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 527
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and Thanks in advance!!
I have a few sheets with many .Outlineed columns (Some of then Collapsed some of then expanded
For this eg my OutLined Columns are:
If I have in range("A1") the value N
I would like to check if N6 is within a Outlined group of columns and show this columns ( Keep the other Coutlined Columns the way they were)
So in my Eg: Expand Columns (M:P) if they are actually collapsed
Any Idea??
I have a few sheets with many .Outlineed columns (Some of then Collapsed some of then expanded
For this eg my OutLined Columns are:
- Columns(C:E)
- Columns(H:J)
- Columns(M:P)
- Columns(V:W)
If I have in range("A1") the value N
I would like to check if N6 is within a Outlined group of columns and show this columns ( Keep the other Coutlined Columns the way they were)
So in my Eg: Expand Columns (M:P) if they are actually collapsed
Any Idea??
VBA Code:
ActiveSheet.Outline.ShowLevels RowLevels:=8, ColumnLevels:=8 'Expand_All
ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 'Collapse_All