VBA code to Collapse Specific Range of grouped cells leaving other ranges expanded

[JasonExcel]

Hi


I am looking for some VBA code to collapse a specific range of grouped cells (row 7 on my sheet) whilst leaving other ranges of grouped cells (rows 37 to 51 on my sheet) expanded. I have tried hunting forums but can only find code to collapse all cells (somthing like ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1). So I have attempted using the following but to no avail:-


Rows("7:7").Outline.ShowLevels RowLevels:=1, ColumnLevels:=1


Any help would be greatly appreciated.
Thanks

 

[JasonExcel]

I've managed to work this one out afterall. Quite easy really:-

Rows(7).EntireRow.ShowDetail = false