#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Groupings and inconsistencies Rod[_2_] Excel Discussion (Misc queries) 3 December 16th 09 05:17 PM
Sorting within Groupings bgc2001 Excel Discussion (Misc queries) 0 November 18th 09 06:06 PM
Variable row groupings Tom Excel Discussion (Misc queries) 3 April 20th 09 01:48 PM
Groupings within PivotTables Fred Excel Worksheet Functions 1 October 18th 05 11:45 PM
Groupings Jason[_28_] Excel Programming 4 January 30th 04 08:08 PM


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"