Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groupings
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
|
|||
|
|||
Groupings
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
|
|||
|
|||
Groupings
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 | |
|
|
Similar Threads | ||||
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 |