ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Groupings (https://www.excelbanter.com/excel-programming/437434-groupings.html)

Rod[_2_]

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)



Dave Peterson

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

Rod[_2_]

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