![]() |
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) |
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 |
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 |
All times are GMT +1. The time now is 11:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com