Excel outline showlevel
 

ActiveSheet.Outline.ShowLevels

The above code only allows me to view either all parents and/or
children or close all parent and/or children.

And VBA dont seem to have support or code that will allow me to select
specific parent or children

What I wish to do, through VBA, is to

1. select only specific parent or children.

2. count the number of children that each parent have

3. access the parent's name or label

4. access the children's name or label

5. count the number of rows that each children may have.

Hope you can help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/