Excel outline showlevel

B

BuggyLogic

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top