Hi
Apologies, I am a VBA newbie and this might be a bit basic...
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