Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
The code: Worksheets("Sheet1").Outline.ShowLevels ColumnLevels:=2 Will expand or collapse grouped columns for a whole sheet, but what code will expand or collapse only one group of columns? E.G. If I group Columns("E:G") and separately group Columns ("X:Z") how can I get some VB code to expand E:G without expanding X:Z? (I can't find anything other than this bit of code in Excel's Help and I can't find anything by searching the Microsoft knowledge base with this group of key words.) Thanks in advance, Kai Richmond |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Outline Data | Excel Discussion (Misc queries) | |||
group and outline | Excel Discussion (Misc queries) | |||
outline | Excel Worksheet Functions | |||
Protection with Outline | Excel Discussion (Misc queries) | |||
biography outline | Excel Discussion (Misc queries) |