Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Having created some groups I want to be able to expand some, and contract others. I can create the groups in code fine, but can only either expand or contract all groups. If I use Record Macro and click on the little + signs it does not create any code. Any clues about how you do this. many thanks Rod (Version Office XP) |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Look at .OutlineLevel in VBA's help.
Rod wrote: Having created some groups I want to be able to expand some, and contract others. I can create the groups in code fine, but can only either expand or contract all groups. If I use Record Macro and click on the little + signs it does not create any code. Any clues about how you do this. many thanks Rod (Version Office XP) -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() ta v. much "Dave Peterson" wrote in message ... Look at .OutlineLevel in VBA's help. Rod wrote: Having created some groups I want to be able to expand some, and contract others. I can create the groups in code fine, but can only either expand or contract all groups. If I use Record Macro and click on the little + signs it does not create any code. Any clues about how you do this. many thanks Rod (Version Office XP) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Groupings and inconsistencies | Excel Discussion (Misc queries) | |||
Sorting within Groupings | Excel Discussion (Misc queries) | |||
Variable row groupings | Excel Discussion (Misc queries) | |||
Groupings within PivotTables | Excel Worksheet Functions | |||
Groupings | Excel Programming |