Thread: Groupings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
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