View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claude Claude is offline
external usenet poster
 
Posts: 36
Default working with grouped rows and columns

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.