ExcelBanter - Show/Hide one of many outline/group levels

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Show/Hide one of many outline/group levels (https://www.excelbanter.com/excel-programming/427081-show-hide-one-many-outline-group-levels.html)

Paul C

Show/Hide one of many outline/group levels

I have a Excel 2003 worksheet with 4 seperate outline/groups.

I start with all outlines collapsed.

I can use this code to expand/show them all

ActiveSheet.Outline.ShowLevels RowLevels:=2

Is there a method in VBA to expand or hide only one of the 4 groups?

All times are GMT +1. The time now is 10:49 AM.