working with grouped rows and columns

C

Claude

Hi all

I have worksheets whith rows and columns grouped over
several levels. I now want to expand or collapse these
grouped rows/columns based on certain criteria (i.e. not
simply all groups on a certain level as in
ActiveSheet.Outline.ShowLevels RowLevels:=5).

Is it at all possible to get a "handle" on a specific
group node, e.g. ActiveSheet.Outline.RowLevels(5,1).Hidden
= True

Thanks for any suggestion.
 

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

Similar Threads

Show/Hide one of many outline/group levels 0
Referring to column or row grouping using VB 1
macro to show / hide grouping, linked to label button 3
Group function with hidden rows 0
find multiple instances and select entire rows 8
Insert SubProject after Task x? (Linking ConsolidateProjects to Task) 0
Problem using group function with hidden rows 0
Run macro on all files in a specific folder 3

Top