ExcelBanter - Expand and Collapse groups

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

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

- - Expand and Collapse groups (https://www.excelbanter.com/excel-programming/406889-expand-collapse-groups.html)

Expand and Collapse groups

I have a range of rows (10 - 15) that are grouped.

Thus

Rows("10:15").Select

How do I collapse and expand the group in vba?

I tried to record the macro while I clicked the + and - signs but it
recorded nothing.

DG

All times are GMT +1. The time now is 05:08 PM.